/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80011
 Source Host           : localhost:3306
 Source Schema         : cat_travel

 Target Server Type    : MySQL
 Target Server Version : 80011
 File Encoding         : 65001

 Date: 04/05/2022 11:42:21
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for gl_category
-- ----------------------------
DROP TABLE IF EXISTS `gl_category`;
CREATE TABLE `gl_category` (
                               `pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
                               `category_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
                               `parent_pid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
                               `gl_count` tinyint(4) NOT NULL DEFAULT '0',
                               `sort` tinyint(4) DEFAULT NULL,
                               `cat_level` tinyint(4) DEFAULT NULL,
                               `category_status` tinyint(4) NOT NULL COMMENT '分类状态，0正常，1暂用',
                               `create_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
                               `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
                               PRIMARY KEY (`pid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='分类';

-- ----------------------------
-- Records of gl_category
-- ----------------------------
BEGIN;
INSERT INTO `gl_category` VALUES ('1', '最新', '0', 1, 1, 1, 1, '2022-04-05 12:23:38', '2022-04-05 12:23:38');
INSERT INTO `gl_category` VALUES ('2', '优选', '0', 1, 2, 1, 1, '2022-04-05 12:24:26', '2022-04-05 12:24:26');
INSERT INTO `gl_category` VALUES ('3', '热门', '0', 1, 3, 1, 1, '2022-04-05 12:24:29', '2022-04-05 12:24:29');
COMMIT;

-- ----------------------------
-- Table structure for gl_info
-- ----------------------------
DROP TABLE IF EXISTS `gl_info`;
CREATE TABLE `gl_info` (
                           `pid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
                           `gl_category_pid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
                           `title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
                           `user_pid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
                           `img_path` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
                           `views` bigint(20) DEFAULT '1' COMMENT '浏览量',
                           `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
                           `gl_status` tinyint(4) DEFAULT '1' COMMENT '状态',
                           `create_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
                           `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
                           PRIMARY KEY (`pid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of gl_info
-- ----------------------------
BEGIN;
INSERT INTO `gl_info` VALUES ('1', '1', '塞外蟠龙湖', '123', '', 10, '# 3.7-3.11本周用到的文档\n\n[代理服务接口设计](https://wiki.inkept.cn/pages/viewpage.action?pageId=163119410)\n\n[审核拉流调度接入文档](https://wiki.inkept.cn/pages/viewpage.action?pageId=17963123)\n\n[2021-12-7 主板9人房视频团战需求](https://wiki.inkept.cn/pages/viewpage.action?pageId=214306681)\n\n[业务方接入代理服务具体操作](https://wiki.inkept.cn/pages/viewpage.action?pageId=169958884)\n\n**[新增海外配置](https://wiki.inkept.cn/pages/viewpage.action?pageId=215745522)**\n\n**[5、新app接入标准化2.0行动项](https://wiki.inkept.cn/pages/viewpage.action?pageId=198826698)**\n\n**[2022-1-26 海外muaah 1v1视频接入](https://wiki.inkept.cn/pages/viewpage.action?pageId=225149914)**\n\n**[2022-2-10 统计多媒体服务端使用裸ip的服务](https://wiki.inkept.cn/pages/viewpage.action?pageId=227476316)**\n\n[接入协议](https://wiki.inkept.cn/pages/viewpage.action?pageId=157191222)\n\n[2022-2-17 丝恋电台接入录播](https://wiki.inkept.cn/pages/viewpage.action?pageId=228699590)\n\n[SDK图片缩放接入信息-研发&运维维护](https://wiki.inkept.cn/pages/viewpage.action?pageId=100813521)\n\n\n\n# 3.7-3.11本周用到的服务器\n\n[录播](https://deployment.inkept.cn/release?jobName=cop.inke_owt.media_pdl.stream_servicegroup.record_service.flv2hls_job.flv2hls_cluster.tx-bj3)\n\n[代理服务qa](https://deployment.inkept.cn/k8sRelease?jobName=cop.inke_owt.media_pdl.common_servicegroup.proxy_service.common_job.proxy_cluster.ali-testqa)\n\n[调度qa](https://deployment.inkept.cn/k8sRelease?jobName=cop.inke_owt.media_pdl.disptacher_servicegroup.load_service.disp_job.recoder_cluster.ali-testqa)\n\n\n\n# 本周计划安排\n\n额外会议\n\n对聊额外重视一下\n\n我们的集群有20多个服务\n\n代理自动挂掉截图和录播\n\n全量查询麦位详情需要更改下\n\n\n\n\n\n# 3.7（周一）\n\n## 代理服务\n\n\n\n\n\n\n\n\n\n\n\n## eryiyi时月直播\n\n### 录播截图 done\n\n\n\n```bash\n2022-03-07 11:12:58.604 server/server.go:611 INFO AddOrDelRoomChangeInfo2Redis flag:success, appname:eryiyi, livetype:eryiyi_normal, liveid:1646622777761271,slot:0, uid:1320052, event:publish, broadcast:start, stream_type:1 {\"trace_id\":\"4e51ee835fb3b3aa64ce754a\",\"namespace\":\"eryiyi\"}\n\n\n\n\n\n```\n\n\n\n\n\n和上周似的了，真是不能拖\n\n重新部署试试\n\n```bash\nhttp://play-aliyun.yingtaorelian.com/yingtaorelian/160194839245170106-1646612339.flv?height=272&width=272\n\ncurl \'http://testqa.apigateway.inkept.cn/api/media/comm_service/room_change\' -d \'{\"app_name\":\"test\",\"live_type\":\"1v1_live\",\"broadcast\":\"start\",\"event\":\"publish\",\"media_type\":\"video\",\"liveid\":\"160194839245170188\",\"uid\":12949486,\"dis_slot\":0,\"slot\":0,\"creator_uid\":12949485,\"publish_addr\":null,\"stream_addr\":\"http://play-aliyun.yingtaorelian.com/yingtaorelian/160194839245170106-1646612339.flv?height=272&width=272\",\"stream_type\":\"1\",\"multi_object_id\":\"audit_test_15622186-12949486\",\"mix_object_id\":null,\"asr_text_callback_url\":null,\"source\":\"audit\",\"shot_type\":\"1\",\"audit_shot_cfg\":{\"pic_width\":\"720\",\"pic_high\":\"1280\",\"screenshot_interval\":2}}\'\n\n\n\n\n\ncurl \'http://testqa.apigateway.inkept.cn/api/media/comm_service/room_change\' -d \'{\"app_name\":\"test\",\"live_type\":\"1v1_live\",\"broadcast\":\"stop\",\"event\":\"unpublish\",\"media_type\":\"video\",\"liveid\":\"160194839245170188\",\"uid\":12949486,\"dis_slot\":0,\"slot\":0,\"creator_uid\":12949485,\"publish_addr\":null,\"stream_addr\":\"http://play-aliyun.yingtaorelian.com/yingtaorelian/160194839245170106-1646612339.flv?height=272&width=272\",\"stream_type\":\"1\",\"multi_object_id\":\"audit_test_15622186-12949486\",\"mix_object_id\":null,\"asr_text_callback_url\":null,\"source\":\"audit\",\"shot_type\":\"1\",\"audit_shot_cfg\":{\"pic_width\":\"720\",\"pic_high\":\"1280\",\"screenshot_interval\":2}}\'\n```\n\n\n\n重新部署还是，获取不到ip，\n\n\n\n\n\n上报存在问题，\n\n\n\n```bash\n接收端：nc -l 9988 < tasks.txt\n发送端：ip add看ip，nc 10.111.75.42 9988 < policy/cdn_dispatch_online.json上传文件到中控机\n\nnc 10.128.0.18 9988 > tasks.txt\n```\n\n\n\n\n\n这个日志分析不出来，重启worker解决\n\n\n\n发现录播worker挂了, cpu100 拉满了，运维重启的服务器\n\n后观察录播正常\n\n\n\n<img src=\"https://raw.githubusercontent.com/xzMhehe/StaticFile_CDN/main/static/mo/20220307151041.png\" width=\"500px\"/>\n\n\n\n## 审核接入录播截图\n\n### 国内已经部署 done\n\n\n\n\n\n\n\n### 海外还需要单独测试\n\n\n\n\n\n\n\n\n\n## 对玩\n\n拉流地址替换源站\n\n\n\n```bash\ntail -f info-20220307.log |grep \'zeconf.thlrs.com\'|grep \'s-mlinks1\' --color\n```\n\n\n\n```bash\n-analyzeduration 1000\n```\n\n\n\n\n\n\n\n```bash\n ⚡ root@ali-c-media-control01  /home/maxinze/cdn_dispatch  ./test -c tx -n cdn_dispatch -o get -t online\nget file:  policy.bak/tx_online_cdn_dispatch_2022_03_07__16_46_26.json\n\n ⚡ root@ali-c-media-control01  /home/maxinze/cdn_dispatch vimdiff policy.bak/tx_online_cdn_dispatch_2022_03_07__16_46_26.json policy/cdn_dispatch_online.json\n2 files to edit\n```\n\n\n\n\n\n源站流正常\n\n\n\n## inke截图排查\n\n\n\n可能打老集群去了，新的数据库数据拼接规则与审核不一致导致审核获取不到数据，\n\n\n\n\n\n# 3.8（周二）\n\n## 美颜库\n\n更新\n\n\n\n大庆的不需要更新\n\n\n\n\n\n## 缩放图\n\n原始请求参数， \n\n\n\n\n\n\n\n条件\n\n\n\n宽高都不传\n\n\n\n\n\n只传高\n\n\n\n\n\n只传宽\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n## 缩放图问题排查\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n# 3.8（周三）\n\n## 待规划\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n# 3.10（周四）\n\n## 待规划\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n# 3.11（周五）\n\n## 待规划\n\n\n\n\n\n\n\n\n\n\n\n\n\n## 周报\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n', 1, '2022-04-09 05:47:47', '2022-04-09 05:47:47');
INSERT INTO `gl_info` VALUES ('2', '1', '避暑山庄', '123', 'https://coding-init-1254329140.cos.ap-beijing.myqcloud.com/detail1.jpg', 20, '# 2.7-2.11本周用到的文档\n\n[代理服务接口设计](https://wiki.inkept.cn/pages/viewpage.action?pageId=163119410)\n\n[审核拉流调度接入文档](https://wiki.inkept.cn/pages/viewpage.action?pageId=17963123)\n\n[2021-12-7 主板9人房视频团战需求](https://wiki.inkept.cn/pages/viewpage.action?pageId=214306681)\n\n[业务方接入代理服务具体操作](https://wiki.inkept.cn/pages/viewpage.action?pageId=169958884)\n\n**[新增海外配置](https://wiki.inkept.cn/pages/viewpage.action?pageId=215745522)**\n\n**[5、新app接入标准化2.0行动项](https://wiki.inkept.cn/pages/viewpage.action?pageId=198826698)**\n\n**[2022-1-26 海外muaah 1v1视频接入](https://wiki.inkept.cn/pages/viewpage.action?pageId=225149914)**\n\n**[2022-2-10 统计多媒体服务端使用裸ip的服务](https://wiki.inkept.cn/pages/viewpage.action?pageId=227476316)**\n\n\n\n# 2.7-2.11本周用到的服务器\n\n[录播](https://deployment.inkept.cn/release?jobName=cop.inke_owt.media_pdl.stream_servicegroup.record_service.flv2hls_job.flv2hls_cluster.tx-bj3)\n\n[代理服务qa](https://deployment.inkept.cn/k8sRelease?jobName=cop.inke_owt.media_pdl.common_servicegroup.proxy_service.common_job.proxy_cluster.ali-testqa)\n\n[调度qa](https://deployment.inkept.cn/k8sRelease?jobName=cop.inke_owt.media_pdl.disptacher_servicegroup.load_service.disp_job.recoder_cluster.ali-testqa)\n\n\n\n\n\n# 2.7（周一）\n\n## 缩放图\n\n### 盲趣Gateway Timeout\n\n```bash\nhttps://imagescale.muju001.com/imageproxy2/dimgm/scaleImage?url=https://img.muju001.com/MTY0MzI3NDM4MjU5OCM0MTkjcG5n.png&w=540&h=540&s=80&c=0&o=1\n\n年后看下这个 盲趣 图片缩放 Gateway Timeout\n@马鑫泽 @陈荣华  \n```\n\n没有接入信息，待接入\n\n\n\n### 业务方问题\n\n\n\n```bash\n你好，请问下，我看imagescaledp.yinglehn.com这个压缩服务好像没生效，能访问，但是访问的图片看上去应该是没压缩过的，目前我只看了yinglehn.com这个，深得我心的其他域名有没有这个问题我没看。这个你这边能看是怎么回事吗\n\n\n\nhttps://imagescaledp.yinglehn.com/imageproxy2/dimgm/scaleImage?url=https%3A%2F%2Ftesth5.yinglehn.com%2Fstatic%2Fmedia%2Fintroduce.7616fb6d.png&w=20&s=8&c=0&o=0\n\n\nhttps://imagescaledp.yinglehn.com/imageproxy2/dimgm/scaleImage?url=https://testh5.yinglehn.com/static/media/introduce.7616fb6d.png&w=20&s=8&c=0&o=0\n```\n\n目前自研已经下掉了，现在需要把图片上传到业务的桶里，添加对应关系 https://wiki.inkept.cn/pages/viewpage.action?pageId=100813521 这边配置了，才能够使用缩放等服务\n\n\n\n### 定时器读取json\n\n```go\nfunc init() {\n	//创建Ticker，设置多长时间触发一次\n	ticker := time.NewTicker(time.Second * time.Duration(24))\n	go func() {\n		for range ticker.C { //遍历ticker.C，如果有值，则会执行do someting，否则阻塞\n			//do someting\n			//配置接入\n			f, err := ioutil.ReadFile(model.COSPATH)\n			if err != nil {\n				log.Errorf(\"Add cos json file err, err:%s\", err)\n			}\n			cos_add := map[string]DomainConfig{}\n			if err = json.Unmarshal(f, &cos_add); err != nil {\n				log.Errorf(\"Decoder cos json failed, err%s\", err)\n			}\n			log.Infof(\"Get cos json succ, json:%+v\", cos_add)\n			for k, v := range cos_add {\n				domains[k] = v\n			}\n			log.Infof(\"Get cos json succ, json:%+v\", cos_add)\n\n			f, err = ioutil.ReadFile(model.OSSPATH)\n			oss_add := map[string]DomainConfig{}\n			if err = json.Unmarshal(f, &oss_add); err != nil {\n				log.Errorf(\"Decoder oss json failed, err%s\", err)\n			}\n			log.Infof(\"Get oss json succ, json:%+v\", oss_add)\n			for k, v := range oss_add {\n				domains[k] = v\n			}\n			log.Infof(\"Get oss json succ, json:%+v\", oss_add)\n			//init falcon to avoid discontinuous graph\n		}\n	}()\n}\n```\n\n\n\n## 接入muaah 国内qa环境\n\n```bash\n闯哥，我们有个新的1V1视频APP叫 muaah ，与chatya类似，需要重新申请即构账号和CDN资源，辛苦帮忙处理一下[抱拳]\n```\n\n\n\n```bash\n@刘清明  @罗俊辉  即构资源已申请appid:3925798673\n推流地址：rtmp://publish-ws.imuaah.com/imuaah/\nrtmp拉流地址：rtmp://rtmp-ws.imuaah.com/imuaah/\nflv拉流地址：http://hdl-ws.imuaah.com/imuaah/\nm3u8拉流地址：http://hls-ws.imuaah.com/imuaah/\n```\n\n\n\n### 审核拉流调度\n\n```bash\n➜  ~  curl \'http://testqa.apigateway.inkept.cn/live/get/multiaddr?app=muaah&from=record\' -d \'{\"id\":\"2160932854379411\",\"publish_url\":[\"http://push.zego.muaah:7788/publish/trans/inkeaudio/mlinkm/1615286962005uHS?ikPath=1\\u0026ikFWUrl=\\u0026ikLog=1\\u0026uid=1309680\\u0026ikBeauty=1\\u0026ikKnDebug=2\\u0026ikEnableDRC=0\\u0026ikExposure=0\\u0026ikFilter=1\\u0026dd_type=0\\u0026ikDisableFaceSei=1\\u0026ikKnIncr=0\\u0026ikLiveType=socialgame_ja-audio\"]}\'\n\n{\"dm_error\":0,\"error_msg\":\"操作成功\",\"id\":\"2160932854379411\",\"mix_stream_addr\":\"\",\"backup_mix_stream_addr\":\"\",\"multi_stream_addr\":[\"http://hdl-ws.imuaah.com/imuaah/s-mlinkm-2160932854379411.flv\"],\"backup_multi_stream_addr\":[\"http://hdl-ws.imuaah.com/imuaah/s-mlinkm-2160932854379411.flv\"]}\n\n\ncurl \'http://testqa.apigateway.inkept.cn/live/get/auditaddr?app=muaah&from=audit&audit_uid=1\' -d \'{\"id\":\"1962789580000010208\",\"uid\":\"100208\"}\'\n//qa环境\n```\n\n\n\n```json\n\"muaah\": {\n        \"1v1\": {\n            \"default\": {\n                \"push.zego.muaah\": {\n                    \"stream_id_format\": \"s-{keyinfo}-{liveid}\",\n                    \"multi_stream_addr\": [\n                        \"http://hdl-ws.imuaah.com/imuaah/%s.flv\"\n                    ],\n                    \"backup_multi_stream_addr\": [\n                        \"http://hdl-ws.imuaah.com/imuaah/%s.flv\"\n                    ]\n                },\n                \"push.zego.muaah:7788\": {\n                    \"stream_id_format\": \"s-{keyinfo}-{liveid}\",\n                    \"multi_stream_addr\": [\n                        \"http://hdl-ws.imuaah.com/imuaah/%s.flv\"\n                    ],\n                    \"backup_multi_stream_addr\": [\n                        \"http://hdl-ws.imuaah.com/imuaah/%s.flv\"\n                    ]\n                }\n            },\n            \"record\": {\n                \"push.zego.muaah\": {\n                    \"stream_id_format\": \"s-{keyinfo}-{liveid}\",\n                    \"multi_stream_addr\": [\n                        \"http://hdl-ws.imuaah.com/imuaah/%s.flv\"\n                    ],\n                    \"backup_multi_stream_addr\": [\n                        \"http://hdl-ws.imuaah.com/imuaah/%s.flv\"\n                    ]\n                },\n                \"push.zego.muaah:7788\": {\n                    \"stream_id_format\": \"s-{keyinfo}-{liveid}\",\n                    \"multi_stream_addr\": [\n                        \"http://hdl-ws.imuaah.com/imuaah/%s.flv\"\n                    ],\n                    \"backup_multi_stream_addr\": [\n                        \"http://hdl-ws.imuaah.com/imuaah/%s.flv\"\n                    ]\n                }\n            },\n            \"audit\": {\n                \"push.zego.muaah\": {\n                    \"stream_id_format\": \"s-{keyinfo}-{liveid}\",\n                    \"multi_stream_addr\": [\n                        \"http://hdl-ws.imuaah.com/imuaah/%s.flv\"\n                    ],\n                    \"backup_multi_stream_addr\": [\n                        \"http://hdl-ws.imuaah.com/imuaah/%s.flv\"\n                    ]\n                },\n                \"push.zego.muaah:7788\": {\n                    \"stream_id_format\": \"s-{keyinfo}-{liveid}\",\n                    \"multi_stream_addr\": [\n                        \"http://hdl-ws.imuaah.com/imuaah/%s.flv\"\n                    ],\n                    \"backup_multi_stream_addr\": [\n                        \"http://hdl-ws.imuaah.com/imuaah/%s.flv\"\n                    ]\n                }\n            }\n        }\n    },\n```\n\n\n\n海外未配置\n\n\n\n### 标准化推流\n\n```json\n        \"app_name == \\\"muaah\\\"\":{\n            \"room_type == 2 && media_type == 1\":{\n                \"true\":{\n                    \"line\":\"zego\",\n                    \"comm_args\":{\n                        \"publish_args\":\"ikSoftAACLev=2&ikAACBitrate=64000\",\n                        \"link_args\":\"ikPath=1\"\n                    }\n                }\n            },\n            \"room_type == 2 && media_type == 0\":{\n                \"true\":{\n                    \"line\":\"zego\",\n                    \"comm_args\":{\n                        \"publish_args\":\"ikSoftAACLev=2&ikAACBitrate=64000\",\n                        \"link_args\":\"ikPath=2\"\n                    }\n                }\n            }\n        },\n```\n\n\n\n```bash\ncurl -d\'{\n    \"uid\":\"715474669\",\n    \"liveid\":\"1624204807307552\",\n    \"app_name\":\"muaah\",\n    \"room_type\":2,\n    \"media_type\":1,\n    \"slot\":0,\n    \"incr\":1,\n    \"atom\":{\n        \"osversion\":\"android_26\",\n        \"ostype\":\"android\",\n        \"cv\":\"IK8.2.11_Android\",\n        \"ua\":\"XiaomiMIX2\",\n        \"cpu\":\"[Adreno_(TM)_540][ARMv8_638_Qualcomm_Technologies,_Inc_MSM8998]\",\n        \"client_ip\":\"81.70.56.55\",\n        \"ori_pub_addr\":\"\",\n        \"landscape\":\"0\"\n    }\n}\' -X POST -H \"Content-Type:application/json\" http://10.128.0.16:3639/api/media/live/push_disp/get_pub_addr\n\n\n{\"dm_error\":0,\"error_msg\":\"success\",\"publish_addr\":\"pzsp://audio.push.zego.muaah/live/mlinkm/1624204807307552?uid=715474669\\u0026ikKnSlot=0\\u0026ikKnIncr=1\\u0026ikDisableFaceSei=1\\u0026ikAACBitrate=64000\\u0026ikFps=15\\u0026ikLog=1\\u0026ikExposure=0\\u0026ikFilter=1\\u0026ikPath=1\\u0026ikSoftAACLev=2\\u0026ikBeauty=1\\u0026ikKnDebug=2\\u0026ikEnableDRC=0\\u0026ikLiveType=muaah_onebyone-audio\\u0026clsInfo=muaah_onebyone-audio\",\"link_addr\":\"pzsp://audio.push.zego.muaah/live/mlinkm/1624204807307552?uid=715474669\\u0026ikKnSlot=0\\u0026ikKnIncr=1\\u0026dpSrc=push\\u0026ikPath=1\\u0026ikLiveType=muaah_onebyone-audio\",\"stream_addr\":\"\",\"stream_multi_addr\":\"\"}\n```\n\n\n\n海外未配置\n\n### 代理服务\n\n```bash\n./linux.sh -a proxy -c al-testqa -o get\ngetFileName get file success! file:./proxyConfig.bak/proxyal-testqa_2022_02_07__16_36_15.json\n\n\n比对替换\n\n./linux.sh -a proxy -c al-testqa -o set\n```\n\n\n\n海外配置，未部署\n\n\n\n### 录播调度\n\n```bash\n ⚡ root@ali-c-media-control01  /home/lijinwang/media.common_config   master ● >R>  ./linux.sh -a recorder -c al-testqa -o get\ngetFileName get file success! file:./recorderConfig.bak/recorderal-testqa_2022_02_07__17_05_19.json\n ⚡ root@ali-c-media-control01  /home/lijinwang/media.common_config   master ● >R> \n ⚡ root@ali-c-media-control01  /home/lijinwang/media.common_config   master ● >R> \n ⚡ root@ali-c-media-control01  /home/lijinwang/media.common_config   master ● >R> vimdiff ./recorderConfig.bak/recorderal-testqa_2022_02_07__17_05_19.json recorderConfig/recorder_test.json\n2 files to edit\n ⚡ root@ali-c-media-control01  /home/lijinwang/media.common_config   master ● >R>  ./linux.sh -a recorder -c al-testqa -o set\nset config success! file:./recorderConfig/recorder_test.json\n ⚡ root@ali-c-media-control01  /home/lijinwang/media.common_config   master ● >R> \n ⚡ root@ali-c-media-control01  /home/lijinwang/media.common_config   master ● >R> \n ⚡ root@ali-c-media-control01  /home/lijinwang/media.common_config   master ● >R>  vimdiff ./recorderConfig.bak/recorderal-testqa_2022_02_07__17_05_19.json recorderConfig/recorder_test.json\n2 files to edit\n ⚡ root@ali-c-media-control01  /home/lijinwang/media.common_config   master ● >R> \n```\n\n\n\n海外配置，未部署\n\n\n\n### 录播work\n\n国内配置中心配置\n\n\n\n海外配置已配置未部署\n\n\n\n\n\n# 2.8（周二）\n\n## 多媒体app接入全\n\n信息参考\n\n[2022-1-26 海外muaah 1v1视频接入](https://wiki.inkept.cn/pages/viewpage.action?pageId=225149914)\n\n<img src=\"https://raw.githubusercontent.com/xzMhehe/StaticFile_CDN/main/static/mo/20220208113115.png\" width=\"600\"/>\n\n\n\n### UMA Session 绑定\n\n<img src=\"https://raw.githubusercontent.com/xzMhehe/StaticFile_CDN/main/static/mo/20220208145905.png\"/>\n\n```bash\n\n# 清空房主地址命令\n\n# 功能测试命令\n\n# 与appname绑定的长链接session设置\n## get session:\n### curl http://localhost:10010/uma/session?appName=muaah\n\n## post session:\n###  curl -X POST http://tx3-media-test01.bj:10010/uma/session?appName=media_std\\&session=510000\n\n## put session:\n### curl -X PUT http://tx3-media-test01.bj:10010/uma/session?appName=media_std\\&session=510000\n\n## delete session:\n### curl -X DELETE http://tx3-media-test01.bj:10010/uma/session?appName=media_std\n```\n\n\n\n### 新增海外配置\n\n```bash\n# media.information_cfg\n## 项目简介\n1. zego账号、zego授权、第三方美颜授权等信息，现有方案都是由app端直接设置给sdk。标准化以后，这些授权信息都由多媒体后台为主，供sdk来查询。\n   \n2. sdk使用http短链接来与后台交互，先检验sdk本地的cache是否是最新的，如果不是则将服务端下发的配置信息返回给sdk端。\n3. 具体需求wiki：https://wiki.inkept.cn/pages/viewpage.action?pageId=152663633\n## 配置说明\n## CHANGELOG\n\n4. 查询命令\ncurl -d\'{\"uid\":\"111\",\"cmd\":\"query\",\"orig\":\"\",\"param\":{\"lic_data_ts\":1615361306,\"pck_name\":\"com.gmlive.tianmi\",\"sdk_ver\":\"1.0.06_mediasdk\",\"cv\":\"inke_8.1.90\",\"pck_value\":\"\"}}\'  \'http://10.111.176.70:9231/api/comm/sdk_cfg\'\n```\n\n\n\n\n\n### [5、新app接入标准化2.0行动项](https://wiki.inkept.cn/pages/viewpage.action?pageId=198826698)\n\n\n\n\n\n## muaah线上\n\n### 审核拉流调度\n\n```bash\n[work@tx2-inno-zoomimg05 ~]$ curl \'http://localhost:4061/live/get/multiaddr?app=muaah&from=record\' -d \'{\"id\":\"2160932854379411\",\"publish_url\":[\"http://push.zego.muaah:7788/publish/trans/inke/mlinks2_1/1899651450000020428?ikPath=2\\\\\\\\u0026ikProfile=3\\\\\\\\u0026ikWidth=576\\\\\\\\u0026ikHeight=1024\\\\\\\\u0026ikBr\"]}\'\n{\"dm_error\":0,\"error_msg\":\"操作成功\",\"id\":\"2160932854379411\",\"mix_stream_addr\":\"\",\"backup_mix_stream_addr\":\"\",\"multi_stream_addr\":[\"http://hdl-ws.imuaah.com/imuaah/s-mlinks2_1-2160932854379411.flv\"],\"backup_multi_stream_addr\":[\"http://hdl-ws.imuaah.com/imuaah/s-mlinks2_1-2160932854379411.flv\"]}\n[work@tx2-inno-zoomimg05 ~]$\n```\n\n\n\n## 缩放图\n\n\n\n### 对缘\n\n\n\n```bash\n原图地址：https://img.yingtaorelian.com/MTYxMzk4NDQ2NTc1NyM3NDcjcG5n.png\n缩放完的地址：https://imagescale.yingtaorelian.com/imageproxy2/dimgm/scaleImage?url=https%3A%2F%2Fimg.yingtaorelian.com%2FMTYxMzk4NDQ2NTc1NyM3NDcjcG5n.png&auto-orient=1&s=100\n```\n\n\n\n目前只支持少宽或者少高。全都少的话就不要缩放了，你们直接处理就行，我们处理的话也是同比例缩放那也是返回原图[@刘继雷](#) [@罗锋18210085737](#) \n\n\n\n宽高都不传的返回原图\n\n```go\n	// 返回原图, 处理对缘wh都不传返回原图\n	if limitImage.ReturnOriginalImage == 1 || (limitImage.Width == 0 && limitImage.Height == 0) {\n		sendHttpBack(w, r, imgData, http.StatusOK, stat_item.StorageType, stat_item.AppName)\n		return\n	}\n```\n\n\n\n\n\n```bash\nhttps://imagescale.kangdinghk.cn/imageproxy2/dimgm/scaleImage?url=https://img.kangdinghk.cn/test.jpg&w=500&h=100&s=90&c=0&o=0&t=4&auto-orient=1&m=1&radius=1&blur=1&sigma=20\n\n\nhttp://localhost:5011/imageproxy2/scaleImage?url=https://img.kangdinghk.cn/test.jpg&w=500&h=100&s=90&c=0&o=0&t=4&auto-orient=1&m=1&radius=1&blur=1&sigma=20\n\n\n\n\nhttps://imagescale.kangdinghk.cn/imageproxy2/dimgm/scaleImage?url=https://img.kangdinghk.cn/test.jpg&w=500&h=500&s=90&c=0&o=0&t=4&auto-orient=1&m=1\n```\n\n\n\n### sweetheart 更新\n\n已更新部署\n\n\n\n\n\n## 老推流调度\n\n\n\n根据这个改，明天改\n\n```bash\'\n      <liaoyue_liaoyue_onebyone_cls>\n          <setting android=\"1\" link_proto=\"5\" />\n          <addr publish_pre=\"krns://cls.push.liaoyue.cn/live/\"\n                publish_suf=\"\"\n                stream_pre=\"http://wssource.rtc.inke.cn/live/\"\n                stream_suf=\".flv?ikHost=ws&amp;ikOp=1&amp;codecInfo=8192&amp;dpSrc=push&amp;ikDnsOp=1001&amp;ikMinBu\n                link_publish_addr=\"krns://cls.push.liaoyue.cn/live_s/{liveid}?ikLinkWidth=576&amp;ikLinkHeight=1024&\n                link_addr=\"krns://cls.pull.liaoyue.cn/live/{liveid}?ikKnSlot=0&amp;dpSrc=push\"\n                link_stream_addr=\"krns://cls.pull.liaoyue.cn/live_s/{liveid}?ikKnSlot={slot}&amp;dpSrc=push\"\n                link_stream_addr_cdn=\"http://wssource.rtc.inke.cn/live/{liveid}_{slot}.flv?ikHost=ws&amp;ikOp=1&amp;\n                weight=\"1\" />\n          <ios_argument>\n              <argument proto=\"0\" publish=\"\" />\n              <argument proto=\"5\" publish=\"?ikProfile=3&amp;ikWidth=576&amp;ikHeight=1024&amp;ikBr=800&amp;ikFps=15&\n          </ios_argument>\n          <android_argument>\n              <argument proto=\"0\" publish=\"\" />\n              <argument proto=\"5\" publish=\"?ikProfile=3&amp;ikWidth=576&amp;ikHeight=1024&amp;ikBr=800&amp;ikFps=15&\n          </android_argument>\n      </liaoyue_liaoyue_onebyone_cls>\n      \n      \n      \n      <liaoyue_liaoyue_onebyone_zego>\n          <setting android=\"1\" link_proto=\"5\" arg_min_proto=\"5\" />\n          <addr forward=\"\"\n                publish_pre=\"http://zego.push.liaoyue.com/publish/trans/inke/mlinkm/\"\n                publish_suf=\"\"\n                stream_pre=\"\"\n                stream_suf=\"\"\n                link_publish_addr=\"http://zego.push.liaoyue.com:7788/publish/trans/inke/mlinks{slot}_{incr}/{liveid}\n                link_addr=\"pzsp://zego.push.liaoyue.com:7788/live/ld/trans/inke/mlinkm/{liveid}?ikPath=2&amp;dpSrc=p\n                link_stream_addr=\"pzsp://zego.push.liaoyue.com:7788/live/ld/trans/inke/mlinks{slot}_{incr}/{liveid}?\n                link_addr_cdn=\"\"\n                link_stream_addr_cdn=\"\"\n                weight=\"1\" />\n          <ios_argument>\n              <argument proto=\"0\" publish=\"\" />\n              <argument proto=\"5\" publish=\"?ikPath=2&amp;ikProfile=3&amp;ikWidth=576&amp;ikHeight=1024&amp;ikBr=800&\n          </ios_argument>\n          <android_argument>\n              <argument proto=\"0\" publish=\"\" />\n              <argument proto=\"5\" publish=\"?ikPath=2&amp;ikProfile=3&amp;ikWidth=576&amp;ikHeight=1024&amp;ikBr=800&\n          </android_argument>\n      </liaoyue_liaoyue_onebyone_zego>\n      \n      \n      <liaoyue_liaoyue_onebyoneaudio_cls>\n          <setting android=\"1\" link_proto=\"5\" />\n          <addr publish_pre=\"krns://audio.cls.push.liaoyue.com/live/\"\n                publish_suf=\"\"\n                stream_pre=\"\"\n                stream_suf=\"\"\n                link_publish_addr=\"krns://audio.cls.push.liaoyue.com/live_s/{liveid}?ikProfile=3&amp;ikKnSlot={slot}\n                link_addr=\"krns://audio.cls.pull.liaoyue.com/live/{liveid}?ikKnSlot=0&amp;dpSrc=push&amp;ikKnFM=1\"\n                link_stream_addr=\"krns://audio.cls.pull.liaoyue.com/live_s/{liveid}?ikKnSlot={slot}&amp;dpSrc=push&a\n                link_stream_addr_cdn=\"\"\n                weight=\"1\" />\n          <ios_argument>\n              <argument proto=\"0\" publish=\"\" />\n              <argument proto=\"5\" publish=\"?ikProfile=3&amp;ikLog=1&amp;ikKnSlot=0&amp;ikFEC=3&amp;ikAACBitrate=3200\n          </ios_argument>\n          <android_argument>\n              <argument proto=\"0\" publish=\"\" />\n              <argument proto=\"5\" publish=\"?ikProfile=3&amp;ikLog=1&amp;ikKnSlot=0&amp;ikFEC=3&amp;ikAACBitrate=3200\n          </android_argument>\n      </liaoyue_liaoyue_onebyoneaudio_cls>\n      \n      \n      \n      <liaoyue_liaoyue_onebyoneaudio_zego>\n          <setting android=\"1\" link_proto=\"5\" />\n          <forward forward=\"\" />\n          <addr publish_pre=\"http://audio.zego.push.liaoyue.com/publish/trans/inkeaudio/mlinkm/\"\n                publish_suf=\"\"\n                stream_pre=\"\"\n                stream_suf=\"\"\n                link_publish_addr=\"http://audio.zego.push.liaoyue.com:7788/publish/trans/inkeaudio/mlinks{slot}_{inc\n                link_addr=\"pzsp://audio.zego.push.liaoyue.com:7788/live/ld/trans/inkeaudio/mlinkm/{liveid}?ikPath=1&\n                link_stream_addr=\"pzsp://audio.zego.push.liaoyue.com:7788/live/ld/trans/inkeaudio/mlinks{slot}_{incr\n                link_addr_cdn=\"\"\n                link_stream_addr_cdn=\"\"\n                weight=\"1\" />\n          <ios_argument>\n              <argument proto=\"0\" publish=\"\" />\n              <argument proto=\"5\" publish=\"?ikPath=1&amp;ikSoftAACLev=2&amp;ikAACBitrate=32000&amp;ikLog=1\" />\n          </ios_argument>\n          <android_argument>\n              <argument proto=\"0\" publish=\"\" />\n              <argument proto=\"5\" publish=\"?ikPath=1&amp;ikSoftAACLev=2&amp;ikAACBitrate=32000&amp;ikLog=1\" />\n          </android_argument>\n      </liaoyue_liaoyue_onebyoneaudio_zego>\n```\n\n\n\n\n\n# 2.9（周三）\n\n## 老推流调度\n\n代码原分支\n\n```bash\nmiddle-m-dev-jqs\n```\n\n现分支\n\n```bash\ninno\n```\n\n\n\n获取测试环境配置\n\n```bash\n[root@ali-a-media-ffmpegbuild01 conf]# ./redis_get.py inno_test\n\nsuccess! policy/online__2022_02_09__10_12_03.xml\n```\n\n\n\n\n\n\n\n```bash\n<live_type namespace=\"sweetheart\" live_type=\"sweetheart_onebyone_cls\" type=\"\" id=\"1001\" key=\"GLOBAL_RADIO_TEST_CLS_ALLOW_CACHE_KEY\" type_pre=\"video_sweetheart_cls_\" link=\"2\" optimal_disable=\"1\" />\n<live_type namespace=\"sweetheart\" live_type=\"sweetheart_onebyone_zego\" type=\"\" id=\"1001\" key=\"GLOBAL_RADIO_TEST_CLS_ALLOW_CACHE_KEY\" type_pre=\"video_sweetheart_zego_\" link=\"2\" optimal_disable=\"1\" />\n```\n\n\n\n\n\n分支找半天发现是 inno_develop_yzy 这个分支\n\n\n\nsweetheart 配置\n\n1v1视频推流地址参考\n\n<img src=\"https://raw.githubusercontent.com/xzMhehe/StaticFile_CDN/main/static/mo/20220209185019.png\"/>\n\n```bash\n    <sweetheart_sweetheart_onebyone_cls>\n        <setting android=\"1\" link_proto=\"5\" />\n        <addr publish_pre=\"krns://push.cls.sweetheart/live/\"\n              publish_suf=\"\"\n              stream_pre=\"\"\n              stream_suf=\"\"\n              link_publish_addr=\"krns://push.cls.sweetheart/live_s/{liveid}?ikLinkWidth=576&amp;ikLinkHeight=1024&amp;ikLinkBr=800&amp;ikMaxBr=800&amp;ikMinBr=600&amp;ikProfile=3&amp;ikWidth=576&amp;ikHeight=1024&amp;ikBr=800&amp;ikKnSlot={slot}&amp;ikLog=1&amp;ikFEC=3&amp;ikNewProcess=1&amp;ikBeauty=1&amp;ikSelfFaceDetect=1&amp;ikFullSelfBeauty=1\"\n              link_addr=\"krns://push.cls.sweetheart/live/{liveid}?ikKnSlot=0&amp;dpSrc=push\"\n              link_stream_addr=\"krns://push.cls.sweetheart/live_s/{liveid}?ikKnSlot={slot}&amp;dpSrc=push\"\n              link_stream_addr_cdn=\"\"\n              weight=\"1\" />\n        <ios_argument>\n            <argument proto=\"0\" publish=\"\" />\n            <argument proto=\"5\" publish=\"?ikProfile=3&amp;ikWidth=576&amp;ikHeight=1024&amp;ikBr=800&amp;ikFps=15&amp;ikMaxBr=800&amp;ikMinBr=600&amp;ikLog=1&amp;ikKnSlot=0&amp;ikFEC=3&amp;ikNewProcess=1&amp;ikBeauty=1&amp;ikSelfFaceDetect=1&amp;ikFullSelfBeauty=1\" />\n        </ios_argument>\n        <android_argument>\n            <argument proto=\"0\" publish=\"\" />\n            <argument proto=\"5\" publish=\"?ikProfile=3&amp;ikWidth=576&amp;ikHeight=1024&amp;ikBr=800&amp;ikFps=15&amp;ikMaxBr=800&amp;ikMinBr=600&amp;ikLog=1&amp;ikKnSlot=0&amp;ikFEC=3&amp;ikNewProcess=1&amp;ikBeauty=1&amp;ikSelfFaceDetect=1&amp;ikFullSelfBeauty=1\" />\n        </android_argument>\n    </sweetheart_sweetheart_onebyone_cls>\n    <sweetheart_sweetheart_onebyone_zego>\n        <setting android=\"1\" link_proto=\"5\" arg_min_proto=\"5\" />\n        <addr forward=\"\"\n              publish_pre=\"pzsp://push.zego.sweetheart/publish/inke/mlinkm/\"\n              publish_suf=\"\"\n              stream_pre=\"\"\n              stream_suf=\"\"\n              link_publish_addr=\"pzsp://push.zego.sweetheart/publish/inke/mlinks{slot}_{incr}/{liveid}?ikPath=2&amp;ikProfile=3&amp;ikWidth=576&amp;ikHeight=1024&amp;ikBr=800&amp;ikMaxBr=800&amp;ikMinBr=600&amp;ikFps=15&amp;ikOp=1&amp;ikLog=1\"\n              link_addr=\"pzsp://push.zego.sweetheart/publish/inke/mlinkm/{liveid}?ikPath=2&amp;dpSrc=push\"\n              link_stream_addr=\"pzsp://push.zego.sweetheart/publish/inke/mlinks{slot}_{incr}/{liveid}?ikPath=2&amp;dpSrc=push\"\n              link_addr_cdn=\"\"\n              link_stream_addr_cdn=\"\"\n              weight=\"1\" />\n        <ios_argument>\n            <argument proto=\"0\" publish=\"\" />\n            <argument proto=\"5\" publish=\"?ikPath=2&amp;ikProfile=3&amp;ikWidth=576&amp;ikHeight=1024&amp;ikBr=800&amp;ikMaxBr=800&amp;ikMinBr=600&amp;ikFps=15&amp;ikOp=1&amp;ikLog=1\" />\n        </ios_argument>\n        <android_argument>\n            <argument proto=\"0\" publish=\"\" />\n            <argument proto=\"5\" publish=\"?ikPath=2&amp;ikProfile=3&amp;ikWidth=576&amp;ikHeight=1024&amp;ikBr=800&amp;ikMaxBr=800&amp;ikMinBr=600&amp;ikFps=15&amp;ikOp=1&amp;ikLog=1\" />\n        </android_argument>\n    </sweetheart_sweetheart_onebyone_zego>\n```\n\n\n\n中途业务方遇到问题，不是我们配置的推流地址，黑屏\n\n```bash\n2022-02-09 14:16:53.830  I/(601)-[ljc][VideoPlayer] start obj:com.inke.tracker.override.TrackVideoPlayer@a8420bb, starturl:pzsp://link.inke.cn:7788/live/ld/trans/inke/mlinks2_1/2139777910000010212?ikHost=pz&ikOp=1&ndselect=3&dpSrc=push&ikLiveType=_onebyone\n2022-02-09 14:16:53.830  I/(601)-[wlz]delay catch start  \n2022-02-09 14:16:53.830  I/(601)-[ljc]delayCatch\n2022-02-09 14:16:53.830  I/(601)-[ljc]normalStart() this:com.inke.tracker.override.TrackVideoPlayer@a8420bb\n2022-02-09 14:16:53.830  I/(601)-[ljc]setDataSource : pzsp://link.inke.cn:7788/live/ld/trans/inke/mlinks2_1/2139777910000010212?ikHost=pz&ikOp=1&ndselect=3&dpSrc=push&ikLiveType=_onebyone\n2022-02-09 14:16:53.831  I/(601)-[MeeLiveSDK]PlayerOpenInfo:{\"audio_mute\":false,\"custom\":null,\"decode_type\":-1,\"detail_time\":\"{\\\"open_status\\\":\\\"failed\\\"\\\"}\",\"domain\":\"link.inke.cn\",\"is_audio\":0,\"keyname\":\"PlayerOpenInfo\",\"live_id\":\"2139777910000010212\",\"live_type\":\"_onebyone\",\"ms_who\":\"\",\"pull_type\":2,\"remote_ssrc\":\"\",\"remote_uid\":\"\",\"server\":\"link.inke.cn\",\"slot\":\"-1\",\"ssrc\":\"\",\"start\":1644387389700}\n2022-02-09 14:16:53.831  E/(601)-[ljc]use SDL_AoutAndroid_CreateForAudioTrack\n2022-02-09 14:16:53.832  E/(2644)-[ljc]1 ffp->node_vdec:0x0 size:4\n```\n\n\n\n排查日志\n\n服务发现名\n\nmedia.dispatch.push_inno\n\ntx3-media-test01.bj\n\n\n\n<img src=\"https://raw.githubusercontent.com/xzMhehe/StaticFile_CDN/main/static/mo/20220209153554.png\"/>\n\n\n\n日志比较奇怪，用的 server.log \n\n```bash\ncat server.log | grep 1643013874580618 --color\n```\n\n推流地址还是有问题，没有生效\n\n\n\n于是我们先自行测试\n\n\n\n### 测试1v1视频\n\n登录中控机\n\nsweetheart\n\n目录  /home/jiangqingshan\n\n\n\n修改 **log.file**\n\n最后一行添加, 参考下方\n\n替换 app_name、live_type、uid\n\n```bash\n2021-11-30 15:43:03.301 140355684398848 INFO [REQUEST_TRACE][getPublishAddr]PublishRequest(uid=931117, cv=ERYIYI1.0.80_Android, proto=0, ip=, atom={\"app_name\":\"sweetheart\",\"ast\":\"1\",\"atid\":\"30\",\"cc\":\"GF10000\",\"conn\":\"wifi\",\"cv\":\"ERYIYI1.0.80_Android\",\"dev_name\":\"Xiaomi\",\"eaid\":\"61636236366563386264653936393232\",\"ik_appid\":\"ZXJ5aXlpOkVSWUlZSQ\",\"lc\":\"3000000000000000\",\"lca_coun\":\"CN\",\"lca_lang\":\"zh\",\"live_type\":\"sweetheart_onebyone\",\"meid\":\"353634333336333330363337353638\",\"mtid\":\"db87e26298d80ef1783bc48fd3d39cc3\",\"mtxid\":\"06b8e6113883\",\"namespace\":\"sweetheart\",\"oaid\":\"cbc1a30418abda6c\",\"ongd\":\"30\",\"osversion\":\"android_28\",\"proto\":\"\",\"sid\":\"03si2yVE2DiMlQ1xhNBEq7QFD6wNrAVz7lR8i2erA03nObPF2X5AbtjWT093hAi3i3\",\"smid\":\"DuRkQ5SF8WH6rtIWmrGSLa7094LOdw/+WkD+dXT9rxkrODsnYu8fXo5tel7iiDP8vLjvHUflsCpxhxuAXWAbGMNQ\",\"ua\":\"XiaomiMIX2\",\"uid\":\"931117\"})\n```\n\n\n\n不是这个\n\n```bash\n2022-01-24 16:44:34.681 140056913118976 INFO [REQUEST_TRACE][getPublishAddr]PublishRequest(uid=931116, cv=LIAOYUE2.0.00_Android, proto=11, ip=182.50.112.2, atom={\"app_name\":\"sweetheart\",\"uid\":931116,\"cv\":\"LIAOYUE2.0.00_Android\",\"proto\":11,\"osversion\":\"android_27\",\"ip\":\"182.50.112.2\",\"xrealip\":\"182.50.112.2\",\"ua\":\"OPPOPBAM00\",\"liveid\":\"1643013874580618\",\"live_type\":\"sweetheart_onebyone\"})\n```\n\n\n\n修改 **my.sh**\n\n<img src=\"https://raw.githubusercontent.com/xzMhehe/StaticFile_CDN/main/static/mo/20220209152851.png\" width=\"500\"/>\n\n(示例图片，测试的就是 inno 环境, 所以放开此行)\n\n\n\n执行 **my.sh**\n\n成功\n\n<img src=\"https://raw.githubusercontent.com/xzMhehe/StaticFile_CDN/main/static/mo/20220209152945.png\"/>\n\n\n\n\n\n测试无误，推流地址正确\n\n告诉业务\n\n```bash\n@大瘾 原子参数appname 、 namespace 、 live_type参考下这个 来传递\natom={\"app_name\":\"sweetheart\",\"ast\":\"1\",\"atid\":\"30\",\"cc\":\"GF10000\",\"conn\":\"wifi\",\"cv\":\"ERYIYI1.0.80_Android\",\"dev_name\":\"Xiaomi\",\"eaid\":\"61636236366563386264653936393232\",\"ik_appid\":\"ZXJ5aXlpOkVSWUlZSQ\",\"lc\":\"3000000000000000\",\"lca_coun\":\"CN\",\"lca_lang\":\"zh\",\"live_type\":\"sweetheart_onebyone\",\"meid\":\"353634333336333330363337353638\",\"mtid\":\"db87e26298d80ef1783bc48fd3d39cc3\",\"mtxid\":\"06b8e6113883\",\"namespace\":\"sweetheart\",\"oaid\":\"cbc1a30418abda6c\",\"ongd\":\"30\",\"osversion\":\"android_28\",\"proto\":\"\",\"sid\":\"03si2yVE2DiMlQ1xhNBEq7QFD6wNrAVz7lR8i2erA03nObPF2X5AbtjWT093hAi3i3\",\"smid\":\"DuRkQ5SF8WH6rtIWmrGSLa7094LOdw/+WkD+dXT9rxkrODsnYu8fXo5tel7iiDP8vLjvHUflsCpxhxuAXWAbGMNQ\",\"ua\":\"XiaomiMIX2\",\"uid\":\"931117\"})\n```\n\n注意原子参数即可\n\n\n\n### 测试1v1语音\n\n还要搞 1v1 语音\n\n<img src=\"https://raw.githubusercontent.com/xzMhehe/StaticFile_CDN/main/static/mo/20220209173419.png\"/>\n\n模仿这个\n\nsweetheart\n\n```bash\n<live_type namespace=\"sweetheart\" live_type=\"sweetheart_onebyone-audio_cls\" type=\"\" id=\"1001\" key=\"GLOBAL_RADIO_TEST_CLS_ALLOW_CACHE_KEY\" type_pre=\"radio_sweetheart_onebyone-audio_cls_\" link=\"2\" optimal_disable=\"1\" />\n<live_type namespace=\"sweetheart\" live_type=\"sweetheart_onebyone-audio_zego\" type=\"\" id=\"1001\" key=\"GLOBAL_RADIO_TEST_CLS_ALLOW_CACHE_KEY\" type_pre=\"radio_sweetheart_onebyone-audio_zego_\" link=\"2\" optimal_disable=\"1\" />\n```\n\n配置了没有生效\n\n解决方案\n\nonebyone-audio 替换 为 onebyoneaudio\n\nsweetheart\n\n```bash\n      <sweetheart_sweetheart_onebyoneaudio_zego>\n        <setting android=\"1\" link_proto=\"5\" />\n        <addr publish_pre=\"pzsp://audio.push.zego.sweetheart/publish/inke/mlinkm/\"\n              publish_suf=\"\"\n              stream_pre=\"\"\n              stream_suf=\"\"\n              link_publish_addr=\"pzsp://audio.push.zego.sweetheart/publish/inkeaudio/mlinks{slot}_{incr}/{liveid}?ikPath=1&amp;ikSoftAACLev=2&amp;ikAACBitrate=32000\"\n              link_addr=\"pzsp://audio.push.zego.sweetheart/live/ld/inkeaudio/mlinkm/{liveid}?ikPath=1&amp;dpSrc=push\"\n              link_stream_addr=\"pzsp://audio.push.zego.sweetheart/live/ld/inkeaudio/mlinks{slot}_{incr}/{liveid}?ikPath=1&amp;dpSrc=push\"\n              link_addr_cdn=\"\"\n              link_stream_addr_cdn=\"\"\n              weight=\"1\" />\n        <ios_argument>\n            <argument proto=\"0\" publish=\"\" />\n            <argument proto=\"5\" publish=\"?ikPath=1&amp;ikSoftAACLev=2&amp;ikAACBitrate=32000&amp;ikLog=1\" />\n        </ios_argument>\n        <android_argument>\n            <argument proto=\"0\" publish=\"\" />\n            <argument proto=\"5\" publish=\"?ikPath=1&amp;ikSoftAACLev=2&amp;ikAACBitrate=32000&amp;ikLog=1\" />\n        </android_argument>\n    </sweetheart_sweetheart_onebyoneaudio_zego> \n    <sweetheart_sweetheart_onebyoneaudio_cls>\n        <setting android=\"1\" link_proto=\"5\" />\n        <addr publish_pre=\"krns://audio.push.cls.sweetheart/live/\"\n              publish_suf=\"\"\n              stream_pre=\"krns://audio.push.cls.sweetheart/live/\"\n              stream_suf=\".flv?ikHost=ws&amp;ikOp=1&amp;codecInfo=8192&amp;dpSrc=push&amp;ikDnsOp=1001&amp;ikMinBuf=2900&amp;ikMaxBuf=3600&amp;ikSlowRate=1.0&amp;ikFastRate=1.1&amp;ikLog=1&amp;ikSyncBeta=1\"\n              link_publish_addr=\"krns://audio.push.cls.sweetheart/live_s/{liveid}?ikProfile=3&amp;ikKnSlot={slot}&amp;ikLog=1&amp;ikFEC=3&amp;ikAACBitrate=64000&amp;ikKnFM=1\"\n              link_addr=\"krns://audio.push.cls.sweetheart/live//{liveid}?ikKnSlot=0&amp;dpSrc=push&amp;ikKnFM=1\"\n              link_stream_addr=\"krns://audio.push.cls.sweetheart/live_s/{liveid}?ikKnSlot={slot}&amp;dpSrc=push&amp;ikKnFM=1\"\n              link_stream_addr_cdn=\"krns://audio.push.cls.sweetheart/live/{liveid}_{slot}.flv?ikHost=ws&amp;ikOp=1&amp;codecInfo=8192&amp;dpSrc=push&amp;ikDnsOp=1001&amp;ikMinBuf=2900&amp;ikMaxBuf=3600&amp;ikSlowRate=0.9&amp;ikFastRate=1.1&amp;ikLog=1&amp;ikSyncBeta=1\"\n              weight=\"1\" />\n        <ios_argument>\n            <argument proto=\"0\" publish=\"\" />\n            <argument proto=\"5\" publish=\"?ikProfile=3&amp;ikFps=15&amp;ikLog=1&amp;ikKnSlot=0&amp;ikFEC=3&amp;ikAACBitrate=64000&amp;ikKnFM=1\" />\n        </ios_argument>\n        <android_argument>\n            <argument proto=\"0\" publish=\"\" />\n            <argument proto=\"5\" publish=\"?ikProfile=3&amp;ikFps=15&amp;ikLog=1&amp;ikKnSlot=0&amp;ikFEC=3&amp;ikAACBitrate=64000&amp;ikKnFM=1\" />\n        </android_argument>\n    </sweetheart_sweetheart_onebyoneaudio_cls>\n```\n\n\n\n\n\n\n\n```bash\n2021-11-30 15:43:03.301 140355684398848 INFO [REQUEST_TRACE][getPublishAddr]PublishRequest(uid=931118, cv=ERYIYI1.0.80_Android, proto=0, ip=, atom={\"app_name\":\"sweetheart\",\"ast\":\"1\",\"atid\":\"30\",\"cc\":\"GF10000\",\"conn\":\"wifi\",\"cv\":\"ERYIYI1.0.80_Android\",\"dev_name\":\"Xiaomi\",\"eaid\":\"61636236366563386264653936393232\",\"ik_appid\":\"ZXJ5aXlpOkVSWUlZSQ\",\"lc\":\"3000000000000000\",\"lca_coun\":\"CN\",\"lca_lang\":\"zh\",\"live_type\":\"sweetheart_onebyoneaudio\",\"meid\":\"353634333336333330363337353638\",\"mtid\":\"db87e26298d80ef1783bc48fd3d39cc3\",\"mtxid\":\"06b8e6113883\",\"namespace\":\"sweetheart\",\"oaid\":\"cbc1a30418abda6c\",\"ongd\":\"30\",\"osversion\":\"android_28\",\"proto\":\"\",\"sid\":\"03si2yVE2DiMlQ1xhNBEq7QFD6wNrAVz7lR8i2erA03nObPF2X5AbtjWT093hAi3i3\",\"smid\":\"DuRkQ5SF8WH6rtIWmrGSLa7094LOdw/+WkD+dXT9rxkrODsnYu8fXo5tel7iiDP8vLjvHUflsCpxhxuAXWAbGMNQ\",\"ua\":\"XiaomiMIX2\",\"uid\":\"931118\"})\n```\n\n\n\n```bash\n2021-11-30 15:43:03.301 140355684398848 INFO [REQUEST_TRACE][getPublishAddr]PublishRequest(uid=931118, cv=ERYIYI1.0.80_Android, proto=0, ip=, atom={\"app_name\":\"sweetheart\",\"ast\":\"1\",\"atid\":\"30\",\"cc\":\"GF10000\",\"conn\":\"wifi\",\"cv\":\"ERYIYI1.0.80_Android\",\"dev_name\":\"Xiaomi\",\"eaid\":\"61636236366563386264653936393232\",\"ik_appid\":\"ZXJ5aXlpOkVSWUlZSQ\",\"lc\":\"3000000000000000\",\"lca_coun\":\"CN\",\"lca_lang\":\"zh\",\"live_type\":\"sweetheart_onebyone-audio\",\"meid\":\"353634333336333330363337353638\",\"mtid\":\"db87e26298d80ef1783bc48fd3d39cc3\",\"mtxid\":\"06b8e6113883\",\"namespace\":\"sweetheart\",\"oaid\":\"cbc1a30418abda6c\",\"ongd\":\"30\",\"osversion\":\"android_28\",\"proto\":\"\",\"sid\":\"03si2yVE2DiMlQ1xhNBEq7QFD6wNrAVz7lR8i2erA03nObPF2X5AbtjWT093hAi3i3\",\"smid\":\"DuRkQ5SF8WH6rtIWmrGSLa7094LOdw/+WkD+dXT9rxkrODsnYu8fXo5tel7iiDP8vLjvHUflsCpxhxuAXWAbGMNQ\",\"ua\":\"XiaomiMIX2\",\"uid\":\"931118\"})\n```\n\n\n\n\n\n# 2.10（周四）\n\n## 老推流调度\n\n\n\n```bash\n类似\n<live_type namespace=\"yochat\" live_type=\"yochat_onebyone-audio_zego\" type=\"\" id=\"1001\" key=\"GLOBAL_RADIO_TEST_CLS_ALLOW_CACHE_KEY\" type_pre=\"radio_yochat_zego_\" link=\"2\" optimal_disable=\"1\" />\n\n\n修改\n<live_type namespace=\"sweetheart\" live_type=\"sweetheart_onebyone-audio_cls\" type=\"\" id=\"1001\" key=\"GLOBAL_RADIO_TEST_CLS_ALLOW_CACHE_KEY\" type_pre=\"radio_sweetheart_onebyone-audio_cls_\" link=\"2\" optimal_disable=\"1\" />\n<live_type namespace=\"sweetheart\" live_type=\"sweetheart_onebyone-audio_zego\" type=\"\" id=\"1001\" key=\"GLOBAL_RADIO_TEST_CLS_ALLOW_CACHE_KEY\" type_pre=\"radio_sweetheart_onebyone-audio_zego_\" link=\"2\" optimal_disable=\"1\" />\n```\n\n\n\n发现 1v1语音 \n\n\n\n\n\n## 广分甜心乐园\n\n### 代理服务\n\n```bash\n    {\n      \"detail\": \"sweetheart接入录播和截图\",\n      \"appname\": \"sweetheart\",\n      \"livetype\": \"onebyone\",\n      \"serverUrl\": [\n       \"media.disp.screenshot:/api/v1/room_change\",\n        \"media.disp.recoder:/api/v1/room_change\"\n      ],\n      \"kafka_topic\": \"\",\n      \"stream_type\": \"1\"\n    },\n    {\n      \"detail\": \"sweetheart接入录播\",\n      \"appname\": \"sweetheart\",\n      \"livetype\": \"onebyone-audio\",\n      \"serverUrl\": [\n        \"media.disp.recoder:/api/v1/room_change\"\n      ],\n      \"kafka_topic\": \"\",\n      \"stream_type\": \"1\"\n    },\n```\n\n\n\n### 录播调度\n\n```bash\n     {\n        \"detail\": \"sweetheart\",\n        \"appname\": \"sweetheart\",\n        \"livetype\": \"onebyone\",\n        \"mode\": \"http\",\n        \"isnew\": true,\n        \"hasAllLiveid\": true,\n        \"app_key\":\"chatya\",\n        \"allliveidURL\": \"http://testqa.apigateway.inkept.cn/api/media/comm_service/allLiveids\",\n        \"mkerDetailURL\": \"http://testqa.apigateway.inkept.cn/api/media/comm_service/mker_detail\",\n        \"whetherMulti\": true\n      },\n      {\n        \"detail\": \"sweetheart\",\n        \"appname\": \"sweetheart\",\n        \"livetype\": \"onebyone-audio\",\n        \"mode\": \"http\",\n        \"isnew\": true,\n        \"hasAllLiveid\": true,\n        \"app_key\":\"media_std\",\n        \"allliveidURL\": \"http://testqa.apigateway.inkept.cn/api/media/comm_service/allLiveids\",\n        \"mkerDetailURL\": \"http://testqa.apigateway.inkept.cn/api/media/comm_service/mker_detail\",\n        \"whetherMulti\": true\n      }\n```\n\n\n\n```bash\n ⚡ root@ali-c-media-control01  /home/lijinwang/media.common_config   master ● >R>  ./linux.sh -a recorder -c al-testqa -o set\nset config success! file:./recorderConfig/recorder_test.json\n```\n\n\n\n### 截图调度\n\n```bash\n     {\n        \"detail\": \"sweetheart\",\n        \"appname\": \"sweetheart\",\n        \"livetype\": \"onebyone\",\n        \"mode\": \"http\",\n        \"isnew\": true,\n        \"hasAllLiveid\": true,\n        \"app_key\": \"inke\",\n        \"allliveidURL\": \"http://testqa.apigateway.inkept.cn/api/media/comm_service/allLiveids\",\n        \"mkerDetailURL\": \"http://testqa.apigateway.inkept.cn/api/media/comm_service/mker_detail\",\n        \"whetherMulti\": true\n      }\n```\n\n\n\n```bash\n ⚡ root@ali-c-media-control01  /home/lijinwang/media.common_config   master ● >R>  ./linux.sh -a screenshot -c al-testqa -o set\nset config success! file:./screenshotConfig/screenshot_test.json\n```\n\n\n\n\n\n### 截图\n\n配置中心qa\n\n\n\n\n\n### 录播 \n\n配置中心qa\n\n\n\n\n\n### 审核拉流调度\n\n\n\n按照chatya\n\n```bash\n\"chatya\": {\n        \"1v1\": {\n            \"default\": {\n                \"push.zego.chatya\": {\n                    \"stream_id_format\": \"s-{keyinfo}-{liveid}\",\n                    \"multi_stream_addr\": [\n                        \"http://hls-ws.ichatya.com/ichatya/%s.flv\"\n                    ],\n                    \"backup_multi_stream_addr\": [\n                        \"http://hls-ws.ichatya.com/ichatya/%s.flv\"\n                    ]\n                },\n                \"push.zego.chatya:7788\": {\n                    \"stream_id_format\": \"s-{keyinfo}-{liveid}\",\n                    \"multi_stream_addr\": [\n                        \"http://hls-ws.ichatya.com/ichatya/%s.flv\"\n                    ],\n                    \"backup_multi_stream_addr\": [\n                        \"http://hls-ws.ichatya.com/ichatya/%s.flv\"\n                    ]\n                }\n            },\n            \"record\": {\n                \"push.zego.chatya\": {\n                    \"stream_id_format\": \"s-{keyinfo}-{liveid}\",\n                    \"multi_stream_addr\": [\n                        \"http://hls-ws.ichatya.com/ichatya/%s.flv\"\n                    ],\n                    \"backup_multi_stream_addr\": [\n                        \"http://hls-ws.ichatya.com/ichatya/%s.flv\"\n                    ]\n                },\n                \"push.zego.chatya:7788\": {\n                    \"stream_id_format\": \"s-{keyinfo}-{liveid}\",\n                    \"multi_stream_addr\": [\n                        \"http://hls-ws.ichatya.com/ichatya/%s.flv\"\n                    ],\n                    \"backup_multi_stream_addr\": [\n                        \"http://hls-ws.ichatya.com/ichatya/%s.flv\"\n                    ]\n                }\n            },\n            \"audit\": {\n                \"push.zego.chatya\": {\n                    \"stream_id_format\": \"s-{keyinfo}-{liveid}\",\n                    \"multi_stream_addr\": [\n                        \"http://hls-ws.ichatya.com/ichatya/%s.flv\"\n                    ],\n                    \"backup_multi_stream_addr\": [\n                        \"http://hls-ws.ichatya.com/ichatya/%s.flv\"\n                    ]\n                },\n                \"push.zego.chatya:7788\": {\n                    \"stream_id_format\": \"s-{keyinfo}-{liveid}\",\n                    \"multi_stream_addr\": [\n                        \"http://hls-ws.ichatya.com/ichatya/%s.flv\"\n                    ],\n                    \"backup_multi_stream_addr\": [\n                        \"http://hls-ws.ichatya.com/ichatya/%s.flv\"\n                    ]\n                }\n            }\n        }\n    }\n```\n\n\n\n原配置有问题,用下面的\n\n```bash\n\"sweetheart\": {\n        \"1v1\": {\n            \"default\": {\n                \"push.cls.sweetheart\": {\n                    \"mix_stream_addr\": \"\",\n                    \"backup_mix_stream_addr\": \"\",\n                    \"multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ],\n                    \"backup_multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ]\n                }\n            },\n            \"record\": {\n                \"push.cls.sweetheart\": {\n                    \"mix_stream_addr\": \"\",\n                    \"backup_mix_stream_addr\": \"\",\n                    \"multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ],\n                    \"backup_multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ]\n                }\n            },\n            \"audit\": {\n                \"audio.push.zego.sweetheart\": {\n                    \"mix_stream_addr\": \"\",\n                    \"backup_mix_stream_addr\": \"\",\n                    \"multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ],\n                    \"backup_multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ]\n                }\n            }\n        }\n    },\n```\n\n\n\n\n\n\n\n最终\n\n```bash\n\"sweetheart\": {\n        \"1v1\": {\n            \"default\": {\n                \"push.cls.sweetheart\": {\n                    \"stream_id_format\": \"s-{keyinfo}-{liveid}\",\n                    \"multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ],\n                    \"backup_multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ]\n                }\n            },\n            \"record\": {\n                \"push.cls.sweetheart\": {\n                    \"stream_id_format\": \"s-{keyinfo}-{liveid}\",\n                    \"multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ],\n                    \"backup_multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ]\n                }\n            },\n            \"audit\": {\n                \"audio.push.zego.sweetheart\": {\n                    \"stream_id_format\": \"s-{keyinfo}-{liveid}\",\n                    \"multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ],\n                    \"backup_multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ]\n                }\n            }\n        }\n    }\n```\n\n\n\n\n\n\n\n```bash\n ⚡ root@ali-c-media-control01  /home/maxinze/cdn_dispatch  vimdiff policy.bak/al_qa_cdn_dispatch_2022_02_10__18_47_\n7.json policy/cdn_dispatch_qa.json\n```\n\n\n\n\n\n\n\n\n\n\n\n# 2.11（周五）\n\n\n\n## 甜心乐园\n\n\n\n### 审核拉流调度\n\n```bash\ncurl \'http://testqa.apigateway.inkept.cn/live/get/multiaddr?app=sweetheart&from=record\' -d \'{\"id\":\"2160932854379411\",\"publish_url\":[\"http://push.zego.sweetheart/publish/inke/mlinkm/2141521350000010347?ikPath=2\\u0026ikProfile=3\\u0026ikWidth=576\\u0026ikHeight=1024\\u0026ikBr=800\\u0026ikMaxBr=800\\u0026ikMinBr=600\\u0026ikFps=15\\u0026ikOp=1\\u0026ikLog=1\\u0026uid=100207\\u0026ikBeauty=1\\u0026ikKnDebug=2\\u0026ikEnableDRC=0\\u0026ikExposure=0\\u0026ikFilter=1\\u0026dd_type=0\\u0026ikDisableFaceSei=1\\u0026ikLiveType=sweetheart_onebyone\"]}\'\n\n\npzsp://push.zego.sweetheart/publish/inke/mlinkm/2141521350000010347?ikPath=2&ikProfile=3&ikWidth=576&ikHeight=1024&ikBr=800&ikMaxBr=800&ikMinBr=600&ikFps=15&ikOp=1&ikLog=1&uid=100207&ikBeauty=1&ikKnDebug=2&ikEnableDRC=0&ikExposure=0&ikFilter=1&dd_type=0&ikDisableFaceSei=1&ikLiveType=sweetheart_onebyone\n```\n\n\n\n```bash\ncurl \'http://testqa.apigateway.inkept.cn/live/get/multiaddr?app=sweetheart&from=record\' -d \'{\"id\":\"2160932854379411\",\"publish_url\":[\"http://push.cls.sweetheart/publish/trans/inkeaudio/mlinkm/1615286962005uHS?ikPath=1\\u0026ikFWUrl=\\u0026ikLog=1\\u0026uid=1309680\\u0026ikBeauty=1\\u0026ikKnDebug=2\\u0026ikEnableDRC=0\\u0026ikExposure=0\\u0026ikFilter=1\\u0026dd_type=0\\u0026ikDisableFaceSei=1\\u0026ikKnIncr=0\\u0026ikLiveType=socialgame_ja-audio\"]}\'\n```\n\n\n\n```bash\ncurl \'http://testqa.apigateway.inkept.cn/live/get/multiaddr?app=sweetheart&from=record\' -d \'{\"id\":\"2160932854379411\",\"publish_url\":[\"pzsp://push.zego.sweetheart/publish/trans/inkeaudio/mlinkm/1615286962005uHS?ikPath=1\\u0026ikFWUrl=\\u0026ikLog=1\\u0026uid=1309680\\u0026ikBeauty=1\\u0026ikKnDebug=2\\u0026ikEnableDRC=0\\u0026ikExposure=0\\u0026ikFilter=1\\u0026dd_type=0\\u0026ikDisableFaceSei=1\\u0026ikKnIncr=0\\u0026ikLiveType=socialgame_ja-audio\"]}\'\n```\n\n\n\n```bash\npzsp://push.zego.sweetheart/publish/inke/mlinkm/2141545190000010212?ikPath=2&ikProfile=3&ikWidth=576&ikHeight=1024&ikBr=800&ikMaxBr=800&ikMinBr=600&ikFps=15&ikOp=1&ikLog=1&uid=100212&ikBeauty=1&ikKnDebug=2&ikEnableDRC=0&ikExposure=0&ikFilter=1&dd_type=0&ikDisableFaceSei=1&ikLiveType=sweetheart_onebyone\n\n\n\ncurl \'http://testqa.apigateway.inkept.cn/live/get/multiaddr?app=sweetheart&from=record\' -d \'{\"id\":\"2160932854379411\",\"publish_url\":[\"pzsp://push.zego.sweetheart/publish/trans/inkeaudio/mlinkm/2141545190000010212?ikPath=2&ikProfile=3&ikWidth=576&ikHeight=1024&ikBr=800&ikMaxBr=800&ikMinBr=600&ikFps=15&ikOp=1&ikLog=1&uid=100212&ikBeauty=1&ikKnDebug=2&ikEnableDRC=0&ikExposure=0&ikFilter=1&dd_type=0&ikDisableFaceSei=1&ikLiveType=sweetheart_onebyone\"]}\'\n\n\n\ncurl \'http://testqa.apigateway.inkept.cn/live/get/multiaddr?app=sweetheart&from=record\' -d \'{\"id\":\"2160932854379411\",\"publish_url\":[\"pzsp://push.zego.sweetheart/publish/inke/mlinkm/2141545190000010212?ikPath=2\\u0026ikProfile=3\\u0026ikWidth=576\\u0026ikHeight=1024\\u0026ikBr=800\\u0026ikMaxBr=800\\u0026ikMinBr=600\\u0026ikFps=15\\u0026ikOp=1\\u0026ikLog=1\\u0026uid=100212\\u0026ikBeauty=1\\u0026ikKnDebug=2\\u0026ikEnableDRC=0\\u0026ikExposure=0\\u0026ikFilter=1\\u0026dd_type=0\\u0026ikDisableFaceSei=1\\u0026ikLiveType=sweetheart_onebyone\"]}\'\n```\n\n\n\n拉流地址配置有问题，多了空格 。。。。。\n\n\n\n\n\n审核拉流调度配置有问题\n\n```bash\n\"sweetheart\": {\n        \"1v1\": {\n            \"default\": {\n                \"push.zego.sweetheart\": {\n                    \"stream_id_format\": \"s-{keyinfo}-{liveid}\",\n                    \"multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ],\n                    \"backup_multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ]\n                },\n                \"audio.push.zego.sweetheart\": {\n                    \"stream_id_format\": \"s-{keyinfo}-{liveid}\",\n                    \"multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ],\n                    \"backup_multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ]\n                },\n                \"push.cls.sweetheart\": {\n                    \"multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ],\n                    \"backup_multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ]\n                },\n                \"audio.push.cls.sweetheart\": {\n                    \"multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ],\n                    \"backup_multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ]\n                }\n            },\n            \"record\": {\n                \"push.zego.sweetheart \": {\n                    \"stream_id_format\": \"s-{keyinfo}-{liveid}\",\n                    \"multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ],\n                    \"backup_multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ]\n                },\n                \"push.cls.sweetheart\": {\n                    \"multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ],\n                    \"backup_multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ]\n                },\n                \"audio.push.zego.sweetheart\": {\n                    \"multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ],\n                    \"backup_multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ]\n                },\n                \"audio.push.cls.sweetheart\": {\n                    \"multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ],\n                    \"backup_multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ]\n                }\n            },\n            \"audit\": {\n                \"push.zego.sweetheart \": {\n                    \"stream_id_format\": \"s-{keyinfo}-{liveid}\",\n                    \"multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ],\n                    \"backup_multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ]\n                },\n                \"push.cls.sweetheart\": {\n                    \"multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ],\n                    \"backup_multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ]\n                },\n                \"audio.push.zego.sweetheart\": {\n                    \"multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ],\n                    \"backup_multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ]\n                },\n                \"audio.push.cls.sweetheart\": {\n                    \"multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ],\n                    \"backup_multi_stream_addr\": [\n                        \"rtmp://qq.orig.inke.cn/sweetheart-zego-pull/live/%s\"\n                    ]\n                }\n            }\n        }\n    }\n```\n\n\n\n\n\n```bash\n ⚡ root@ali-c-media-control01  /home/maxinze/cdn_dispatch  vimdiff policy.bak/al_qa_cdn_dispatch_2022_02_11__13_06_23.json policy/cdn_dispatch_qa.json\n2 files to edit\n```\n\n\n\n\n\n\n\n\n\n\n\n## [2022-2-10 统计多媒体服务端使用裸ip的服务](https://wiki.inkept.cn/pages/viewpage.action?pageId=227476316)\n\n\n\n\n\n```bash\ngrep -r -E \"([0-9]{1,3}\\.){3}[0-9]\" ./*\n```\n\n\n\n\n\n\n\n## 广分甜心乐园\n\n\n\n\n\n```bash\n<live_type namespace=\"sweetheart\" live_type=\"sweetheart_onebyone_cls\" type=\"\" id=\"1001\" key=\"GLOBAL_RADIO_TEST_CLS_ALLOW_CACHE_KEY\" type_pre=\"video_sweetheart_cls_\" link=\"2\" optimal_disable=\"1\" />\n<live_type namespace=\"sweetheart\" live_type=\"sweetheart_onebyone_zego\" type=\"\" id=\"1001\" key=\"GLOBAL_RADIO_TEST_CLS_ALLOW_CACHE_KEY\" type_pre=\"video_sweetheart_zego_\" link=\"2\" optimal_disable=\"1\" />\n<live_type namespace=\"sweetheart\" live_type=\"sweetheart_onebyone-audio_cls\" type=\"\" id=\"1001\" key=\"GLOBAL_RADIO_TEST_CLS_ALLOW_CACHE_KEY\" type_pre=\"radio_sweetheart_onebyone-audio_cls_\" link=\"2\" optimal_disable=\"1\" />\n<live_type namespace=\"sweetheart\" live_type=\"sweetheart_onebyone-audio_zego\" type=\"\" id=\"1001\" key=\"GLOBAL_RADIO_TEST_CLS_ALLOW_CACHE_KEY\" type_pre=\"radio_sweetheart_onebyone-audio_zego_\" link=\"2\" optimal_disable=\"1\" />\n```\n\n\n\n\n\n```bash\n    <sweetheart_sweetheart_onebyone_cls>\n        <setting android=\"1\" link_proto=\"5\" />\n        <addr publish_pre=\"krns://push.cls.sweetheart/live/\"\n              publish_suf=\"\"\n              stream_pre=\"\"\n              stream_suf=\"\"\n              link_publish_addr=\"krns://push.cls.sweetheart/live_s/{liveid}?ikLinkWidth=576&amp;ikLinkHeight=1024&amp;ikLinkBr=800&amp;ikMaxBr=800&amp;ikMinBr=600&amp;ikProfile=3&amp;ikWidth=576&amp;ikHeight=1024&amp;ikBr=800&amp;ikKnSlot={slot}&amp;ikLog=1&amp;ikFEC=3&amp;ikNewProcess=1&amp;ikBeauty=1&amp;ikSelfFaceDetect=1&amp;ikFullSelfBeauty=1\"\n              link_addr=\"krns://push.cls.sweetheart/live/{liveid}?ikKnSlot=0&amp;dpSrc=push\"\n              link_stream_addr=\"krns://push.cls.sweetheart/live_s/{liveid}?ikKnSlot={slot}&amp;dpSrc=push\"\n              link_stream_addr_cdn=\"\"\n              weight=\"1\" />\n        <ios_argument>\n            <argument proto=\"0\" publish=\"\" />\n            <argument proto=\"5\" publish=\"?ikProfile=3&amp;ikWidth=576&amp;ikHeight=1024&amp;ikBr=800&amp;ikFps=15&amp;ikMaxBr=800&amp;ikMinBr=600&amp;ikLog=1&amp;ikKnSlot=0&amp;ikFEC=3&amp;ikNewProcess=1&amp;ikBeauty=1&amp;ikSelfFaceDetect=1&amp;ikFullSelfBeauty=1\" />\n        </ios_argument>\n        <android_argument>\n            <argument proto=\"0\" publish=\"\" />\n            <argument proto=\"5\" publish=\"?ikProfile=3&amp;ikWidth=576&amp;ikHeight=1024&amp;ikBr=800&amp;ikFps=15&amp;ikMaxBr=800&amp;ikMinBr=600&amp;ikLog=1&amp;ikKnSlot=0&amp;ikFEC=3&amp;ikNewProcess=1&amp;ikBeauty=1&amp;ikSelfFaceDetect=1&amp;ikFullSelfBeauty=1\" />\n        </android_argument>\n    </sweetheart_sweetheart_onebyone_cls>\n    <sweetheart_sweetheart_onebyone_zego>\n        <setting android=\"1\" link_proto=\"5\" arg_min_proto=\"5\" />\n        <addr forward=\"\"\n              publish_pre=\"pzsp://push.zego.sweetheart/publish/trans/inke/mlinkm/\"\n              publish_suf=\"\"\n              stream_pre=\"\"\n              stream_suf=\"\"\n              link_publish_addr=\"pzsp://push.zego.sweetheart/publish/trans/inke/mlinks{slot}_{incr}/{liveid}?ikPath=2&amp;ikProfile=3&amp;ikWidth=576&amp;ikHeight=1024&amp;ikBr=800&amp;ikMaxBr=800&amp;ikMinBr=600&amp;ikFps=15&amp;ikOp=1&amp;ikLog=1\"\n              link_addr=\"pzsp://push.zego.sweetheart/live/ld/trans/inke/mlinkm/{liveid}?ikPath=2&amp;dpSrc=push\"\n              link_stream_addr=\"pzsp://push.zego.sweetheart/live/ld/trans/inke/mlinks{slot}_{incr}/{liveid}?ikPath=2&amp;dpSrc=push\"\n              link_addr_cdn=\"\"\n              link_stream_addr_cdn=\"\"\n              weight=\"1\" />\n        <ios_argument>\n            <argument proto=\"0\" publish=\"\" />\n            <argument proto=\"5\" publish=\"?ikPath=2&amp;ikProfile=3&amp;ikWidth=576&amp;ikHeight=1024&amp;ikBr=800&amp;ikMaxBr=800&amp;ikMinBr=600&amp;ikFps=15&amp;ikOp=1&amp;ikLog=1\" />\n        </ios_argument>\n        <android_argument>\n            <argument proto=\"0\" publish=\"\" />\n            <argument proto=\"5\" publish=\"?ikPath=2&amp;ikProfile=3&amp;ikWidth=576&amp;ikHeight=1024&amp;ikBr=800&amp;ikMaxBr=800&amp;ikMinBr=600&amp;ikFps=15&amp;ikOp=1&amp;ikLog=1\" />\n        </android_argument>\n    </sweetheart_sweetheart_onebyone_zego>\n    <sweetheart_sweetheart_onebyone-audio_zego>\n        <setting android=\"1\" link_proto=\"5\" />\n        <addr publish_pre=\"pzsp://audio.push.zego.sweetheart/publish/inke/mlinkm/\"\n              publish_suf=\"\"\n              stream_pre=\"\"\n              stream_suf=\"\"\n              link_publish_addr=\"pzsp://audio.push.zego.sweetheart/publish/trans/inkeaudio/mlinks{slot}_{incr}/{liveid}?ikPath=1&amp;ikSoftAACLev=2&amp;ikAACBitrate=32000\"\n              link_addr=\"pzsp://audio.push.zego.sweetheart/live/ld/trans/inkeaudio/mlinkm/{liveid}?ikPath=1&amp;dpSrc=push\"\n              link_stream_addr=\"pzsp://audio.push.zego.sweetheart/live/ld/trans/inkeaudio/mlinks{slot}_{incr}/{liveid}?ikPath=1&amp;dpSrc=push\"\n              link_addr_cdn=\"\"\n              link_stream_addr_cdn=\"\"\n              weight=\"1\" />\n        <ios_argument>\n            <argument proto=\"0\" publish=\"\" />\n            <argument proto=\"5\" publish=\"?ikPath=1&amp;ikSoftAACLev=2&amp;ikAACBitrate=32000&amp;ikLog=1\" />\n        </ios_argument>\n        <android_argument>\n            <argument proto=\"0\" publish=\"\" />\n            <argument proto=\"5\" publish=\"?ikPath=1&amp;ikSoftAACLev=2&amp;ikAACBitrate=32000&amp;ikLog=1\" />\n        </android_argument>\n    </sweetheart_sweetheart_onebyone-audio_zego> \n    <sweetheart_sweetheart_onebyone-audio_cls>\n        <setting android=\"1\" link_proto=\"5\" />\n        <addr publish_pre=\"krns://audio.push.cls.sweetheart/live/\"\n              publish_suf=\"\"\n              stream_pre=\"krns://audio.push.cls.sweetheart/live/\"\n              stream_suf=\".flv?ikHost=ws&amp;ikOp=1&amp;codecInfo=8192&amp;dpSrc=push&amp;ikDnsOp=1001&amp;ikMinBuf=2900&amp;ikMaxBuf=3600&amp;ikSlowRate=1.0&amp;ikFastRate=1.1&amp;ikLog=1&amp;ikSyncBeta=1\"\n              link_publish_addr=\"krns://audio.push.cls.sweetheart/live_s/{liveid}?ikProfile=3&amp;ikKnSlot={slot}&amp;ikLog=1&amp;ikFEC=3&amp;ikAACBitrate=64000&amp;ikKnFM=1\"\n              link_addr=\"krns://audio.push.cls.sweetheart/live//{liveid}?ikKnSlot=0&amp;dpSrc=push&amp;ikKnFM=1\"\n              link_stream_addr=\"krns://audio.push.cls.sweetheart/live_s/{liveid}?ikKnSlot={slot}&amp;dpSrc=push&amp;ikKnFM=1\"\n              link_stream_addr_cdn=\"krns://audio.push.cls.sweetheart/live/{liveid}_{slot}.flv?ikHost=ws&amp;ikOp=1&amp;codecInfo=8192&amp;dpSrc=push&amp;ikDnsOp=1001&amp;ikMinBuf=2900&amp;ikMaxBuf=3600&amp;ikSlowRate=0.9&amp;ikFastRate=1.1&amp;ikLog=1&amp;ikSyncBeta=1\"\n              weight=\"1\" />\n        <ios_argument>\n            <argument proto=\"0\" publish=\"\" />\n            <argument proto=\"5\" publish=\"?ikProfile=3&amp;ikFps=15&amp;ikLog=1&amp;ikKnSlot=0&amp;ikFEC=3&amp;ikAACBitrate=64000&amp;ikKnFM=1\" />\n        </ios_argument>\n        <android_argument>\n            <argument proto=\"0\" publish=\"\" />\n            <argument proto=\"5\" publish=\"?ikProfile=3&amp;ikFps=15&amp;ikLog=1&amp;ikKnSlot=0&amp;ikFEC=3&amp;ikAACBitrate=64000&amp;ikKnFM=1\" />\n        </android_argument>\n    </sweetheart_sweetheart_onebyone-audio_cls>\n```\n\n\n\n\n\n测试视频\n\n```bash\n2021-11-30 15:43:03.301 140355684398848 INFO [REQUEST_TRACE][getPublishAddr]PublishRequest(uid=931111, cv=ERYIYI1.0.80_Android, proto=0, ip=, atom={\"app_name\":\"sweetheart\",\"ast\":\"1\",\"atid\":\"30\",\"cc\":\"GF10000\",\"conn\":\"wifi\",\"cv\":\"ERYIYI1.0.80_Android\",\"dev_name\":\"Xiaomi\",\"eaid\":\"61636236366563386264653936393232\",\"ik_appid\":\"ZXJ5aXlpOkVSWUlZSQ\",\"lc\":\"3000000000000000\",\"lca_coun\":\"CN\",\"lca_lang\":\"zh\",\"live_type\":\"sweetheart_onebyone\",\"meid\":\"353634333336333330363337353638\",\"mtid\":\"db87e26298d80ef1783bc48fd3d39cc3\",\"mtxid\":\"06b8e6113883\",\"namespace\":\"sweetheart\",\"oaid\":\"cbc1a30418abda6c\",\"ongd\":\"30\",\"osversion\":\"android_28\",\"proto\":\"\",\"sid\":\"03si2yVE2DiMlQ1xhNBEq7QFD6wNrAVz7lR8i2erA03nObPF2X5AbtjWT093hAi3i3\",\"smid\":\"DuRkQ5SF8WH6rtIWmrGSLa7094LOdw/+WkD+dXT9rxkrODsnYu8fXo5tel7iiDP8vLjvHUflsCpxhxuAXWAbGMNQ\",\"ua\":\"XiaomiMIX2\",\"uid\":\"931111\"})\n```\n\n\n\n\n\n测试音频\n\n```bash\n2021-11-30 15:43:03.301 140355684398848 INFO [REQUEST_TRACE][getPublishAddr]PublishRequest(uid=931118, cv=ERYIYI1.0.80_Android, proto=0, ip=, atom={\"app_name\":\"sweetheart\",\"ast\":\"1\",\"atid\":\"30\",\"cc\":\"GF10000\",\"conn\":\"wifi\",\"cv\":\"ERYIYI1.0.80_Android\",\"dev_name\":\"Xiaomi\",\"eaid\":\"61636236366563386264653936393232\",\"ik_appid\":\"ZXJ5aXlpOkVSWUlZSQ\",\"lc\":\"3000000000000000\",\"lca_coun\":\"CN\",\"lca_lang\":\"zh\",\"live_type\":\"sweetheart_onebyone-audio\",\"meid\":\"353634333336333330363337353638\",\"mtid\":\"db87e26298d80ef1783bc48fd3d39cc3\",\"mtxid\":\"06b8e6113883\",\"namespace\":\"sweetheart\",\"oaid\":\"cbc1a30418abda6c\",\"ongd\":\"30\",\"osversion\":\"android_28\",\"proto\":\"\",\"sid\":\"03si2yVE2DiMlQ1xhNBEq7QFD6wNrAVz7lR8i2erA03nObPF2X5AbtjWT093hAi3i3\",\"smid\":\"DuRkQ5SF8WH6rtIWmrGSLa7094LOdw/+WkD+dXT9rxkrODsnYu8fXo5tel7iiDP8vLjvHUflsCpxhxuAXWAbGMNQ\",\"ua\":\"XiaomiMIX2\",\"uid\":\"931118\"})\n```\n\n\n\n\n\n\n\n```bash\n[root@ali-a-media-ffmpegbuild01 conf]# ./redis_get.py get inno_test\n\nsuccess! policy/test_inno__2022_02_11__16_49_14.xml\n\n[root@ali-a-media-ffmpegbuild01 conf]# vimdiff policy/test_inno__2022_02_11__16_49_14.xml service_inno_test.xml\n2 files to edit\n[root@ali-a-media-ffmpegbuild01 conf]# ./redis_set.py set inno_test\n<Element \'data\' at 0x7fc96540ee40>\n\nTrue\n```\n\n\n\n\n\n\n\n\n\n\n\n```bash\n/2141592570000010241?ikPath=2&ikProfile=3&ikWidth=576&ikHeight=1024&ikBr=800&ikMaxBr=800&ikMinBr=600&ikFps=15&ikOp=1&ikLog=1&uid=100240&ikBeauty=1&ikKnDebug=2&ikEnableDRC=0&ikExposure=0&ikFilter=1&dd_type=0&ikDisableFaceSei=1&ikLiveType=sweetheart_onebyone\n\npzsp://push.zego.sweetheart/publish/trans/inke/mlinkm/\npzsp://push.zego.sweetheart/publish/trans/inke/mlinkm/\npzsp://push.zego.sweetheart/publish/inke/mlinkm/\npzsp://push.zego.sweetheart/publish/inke/mlinkm/\npzsp://push.zego.sweetheart/publish/trans/inke/mlinkm/2141592570000010241?ikPath=2&ikProfile=3&ikWidth=576&ikHeight=1024&ikBr=800&ikMaxBr=800&ikMinBr=600&ikFps=15&ikOp=1&ikLog=1&uid=100240&ikBeauty=1&ikKnDebug=2&ikEnableDRC=0&ikExposure=0&ikFilter=1&dd_type=0&ikDisableFaceSei=1&ikLiveType=sweetheart_onebyone\n\n\ncurl \'http://testqa.apigateway.inkept.cn/live/get/multiaddr?app=sweetheart&from=record\' -d \'{\"id\":\"2160932854379411\",\"publish_url\":[\"pzsp://push.zego.sweetheart/publish/trans/inke/mlinkm/2141592570000010241?ikPath=2&ikProfile=3&ikWidth=576&ikHeight=1024&ikBr=800&ikMaxBr=800&ikMinBr=600&ikFps=15&ikOp=1&ikLog=1&uid=100240&ikBeauty=1&ikKnDebug=2&ikEnableDRC=0&ikExposure=0&ikFilter=1&dd_type=0&ikDisableFaceSei=1&ikLiveType=sweetheart_onebyone\"]}\'\n```\n\n\n\n\n\n## 新加坡muaah问题排查\n\n排查是uma的问题说下周在查\n\n\n\n\n\n## 周报\n\n\n\n\n\n\n\n\n\n\n\n## 总结\n\n接触了新的配置，实践中\n\n\n\n', 1, '2022-04-09 06:51:46', '2022-04-09 06:51:46');
INSERT INTO `gl_info` VALUES ('3', '1', '双塔山', '123', 'https://coding-init-1254329140.cos.ap-beijing.myqcloud.com/data/shuangtashan1.jpeg', 11, '# 1.4-1.7本周用到的文档\n\n[代理服务接口设计](https://wiki.inkept.cn/pages/viewpage.action?pageId=163119410)\n\n[审核拉流调度接入文档](https://wiki.inkept.cn/pages/viewpage.action?pageId=17963123)\n\n[2021-12-7 主板9人房视频团战需求](https://wiki.inkept.cn/pages/viewpage.action?pageId=214306681)\n\n[业务方接入代理服务具体操作](https://wiki.inkept.cn/pages/viewpage.action?pageId=169958884)\n\n\n\n\n\n# 1.4-1.7本周用到的服务器\n\n[录播](https://deployment.inkept.cn/release?jobName=cop.inke_owt.media_pdl.stream_servicegroup.record_service.flv2hls_job.flv2hls_cluster.tx-bj3)\n\n[代理服务qa](https://deployment.inkept.cn/k8sRelease?jobName=cop.inke_owt.media_pdl.common_servicegroup.proxy_service.common_job.proxy_cluster.ali-testqa)\n\n[调度qa](https://deployment.inkept.cn/k8sRelease?jobName=cop.inke_owt.media_pdl.disptacher_servicegroup.load_service.disp_job.recoder_cluster.ali-testqa)\n\n\n\n\n\n# 1.4（周二）\n\n## 截图\n\n###  eryiyi截图排查 时月直播\n\n\n\n1641262543531983\n\n```bash\nINFO\n\n./bin/mp4_2_jpeg logs/eryiyi http://qq.orig.internal.inke.cn/bujiu-record-pull/live/1641262543531983_0_en.flv?msUid=screenshot /a8root/work/data/media.operimg.screenshotworker/eryiyi/89/1641262543531983 256 448 4000 -o\n```\n\n\n\n```bash\n2022-01-04 11:05:26.385 runtime/asm_amd64.s:1357 INFO [SCREENSHOT LIVEID LIFE INFO 1641264871150450]============= Screenshot Time outcontext canceled\n```\n\n\n\n<img src=\"https://raw.githubusercontent.com/xzMhehe/StaticFile_CDN/main/static/mo/20220104112142.png\"/>\n\n\n\nINFO [SCREENSHOT LIVEID LIFE INFO 1641264871150450]============= Screenshot Time outcontext canceled\n\n\n\n\n\nliveid 1641264871150450\n\n```bash\nhttps://testaudit.me.inke.cn/check/live-check/detail?live_id=1641264871150450&config_id=28&from=now_live\n```\n\n\n\n所以说这应该是完整的日志，一直在循环这一个错误\n\n```bash\n2022-01-04 11:05:29.054 screenshot/screenshotmanager.go:283 INFO [SCREENSHOT LIVEID LIFE INFO 1641264871150450]start exec cmd: ./bin/mp4_2_jpeg logs/eryiyi http://qq.orig.internal.inke.cn/bujiu-record-pull/live/1641264871150450_0_en.flv?msUid=screenshot /a8root/work/data/media.operimg.screenshotworker/eryiyi/17/1641264871150450 256 448 4000 -o\n2022-01-04 11:05:29.054 screenshot/screenshotmanager.go:283 ERROR ScreenShot Start Hget err redigo: nil returned 1641264871150450\n2022-01-04 11:05:29.054 screenshot/screenshot.go:235 INFO ScreenShot taskStatusMonitor key :IMG_CHECK_ERYIYI_1641264871150450 40\n2022-01-04 11:05:33.727 runtime/asm_amd64.s:1357 INFO ScreenShotManager heartbeat\n2022-01-04 11:05:38.727 runtime/asm_amd64.s:1357 INFO ScreenShotManager heartbeat\n2022-01-04 11:05:43.727 runtime/asm_amd64.s:1357 INFO ScreenShotManager heartbeat\n2022-01-04 11:05:48.727 runtime/asm_amd64.s:1357 INFO ScreenShotManager heartbeat\n2022-01-04 11:05:49.056 screenshot/screenshot.go:398 ERROR ScreenShot taskStatusMonitor get redis key err:IMG_CHECK_ERYIYI_1641264871150450 redigo: nil returned\n2022-01-04 11:05:53.727 runtime/asm_amd64.s:1357 INFO ScreenShotManager heartbeat\n2022-01-04 11:05:57.577 runtime/asm_amd64.s:1357 INFO [SCREENSHOT LIVEID LIFE INFO 1641264871150450]ScreenShot process is done exit status 253\n\n\n\n2022-01-04 11:05:57.577 runtime/asm_amd64.s:1357 INFO [SCREENSHOT LIVEID LIFE INFO 1641264871150450]ScreenShot process is quit is %!s(MISSING)\n2022-01-04 11:05:57.577 screenshot/screenshotmanager.go:343 INFO [SCREENSHOT LIVEID LIFE INFO 1641264871150450]ScreenShot is stopped.\n2022-01-04 11:05:57.577 runtime/asm_amd64.s:1357 INFO [SCREENSHOT LIVEID LIFE INFO 1641264871150450]============= Screenshot Time outcontext canceled\n2022-01-04 11:05:57.577 runtime/asm_amd64.s:1357 INFO ScreenShot taskStatusMonitor exit 1641264871150450\n2022-01-04 11:05:57.581 runtime/asm_amd64.s:1357 INFO ScreenShot Done info increase by result 1641264871150450 66\n2022-01-04 11:05:58.727 runtime/asm_amd64.s:1357 INFO ScreenShotManager heartbeat\n2022-01-04 11:06:00.225 runtime/asm_amd64.s:1357 INFO ScreenShotManager reading info from chan &{0xc0001e0000 eryiyi 0001-01-01 00:00:00 +0000 UTC 1641264871150450_0  } true\n```\n\n\n\n\n\n```bash\ncurl \'http://testqa.apigateway.inkept.cn/api/media/comm_service/room_change\' -d \'{\"app_name\":\"eryiyi\",\"live_type\":\"eryiyi_normal\",\"broadcast\":\"start\",\"event\":\"publish\",\"media_type\":\"video\",\"liveid\":\"test_eryiyi_15622185\",\"uid\":1320052,\"dis_slot\":0,\"slot\":0,\"creator_uid\":12949485,\"publish_addr\":null,\"stream_addr\":\"https://audit-pull-ws.inke.cn/live/1641277798709796.flv?txSecret=abd49e94fb54a2d4ac692661a3d37907&txTime=61B85550\",\"stream_type\":\"1\",\"multi_object_id\":\"test_15622185-12949485\",\"mix_object_id\":null,\"asr_text_callback_url\":null,\"shot_type\":\"\"}\'\n\n\n\n\ncurl \'http://testqa.apigateway.inkept.cn/api/media/comm_service/room_change\' -d \'{\"app_name\":\"eryiyi\",\"live_type\":\"eryiyi_normal\",\"broadcast\":\"stop\",\"event\":\"unpublish\",\"media_type\":\"video\",\"liveid\":\"test_eryiyi_15622185\",\"uid\":1320052,\"dis_slot\":0,\"slot\":0,\"creator_uid\":12949485,\"publish_addr\":null,\"stream_addr\":\"https://audit-pull-ws.inke.cn/live/1641277798709796_0_en.flv?txSecret=abd49e94fb54a2d4ac692661a3d37907&txTime=61B85550\",\"stream_type\":\"1\",\"multi_object_id\":\"test_15622185-12949485\",\"mix_object_id\":null,\"asr_text_callback_url\":null,\"shot_type\":\"\"}\'\n\n自己测试没问题\n\n\n\n\n业务方：eryiyi\n\nhttp://audit-pull-ws.inke.cn/live/1641279811748563_0_en.flv?msUid=1&auth_version=1&from=audit&ts=1641279829&md5sum=ec6b  正常（审核后台直播流地址）\n\n\nffplay http://audit-pull-ws.inke.cn/live/1641279811748563_0.flv?msUid=1&auth_version=1&from=audit&ts=1641279829&md5sum=ec6b 正常\n\nhttp://audit-pull-ws.inke.cn/live/1641277798709796_0_en.flv?msUid=1&auth_version=1&from=audit&ts=1641279963&md5sum=9a19 失败 （审核后台直播流地址）\n\nffplay http://audit-pull-ws.inke.cn/live/1641277798709796_0.flv?msUid=1&auth_version=1&from=audit&ts=1641279963&md5sum=9a19 报黄失败\n```\n\n<font color=\"#**orange**\">[flv @ 0x12990c000] Video codec (c) is not implemented. Update your FFmpeg version to the newest one from Git. If the problem still occurs, it means that your file has a feature which has not been implemented.\n[flv @ 0x12990c000] If you want to help, upload a sample of this file to https://streams.videolan.org/upload/ and contact the ffmpeg-devel mailing list. (ffmpeg-devel@ffmpeg.org)</font>\n\n```bash\nffplay http://audit-pull-ws.inke.cn/live/1641277798709796_0_en.flv?msUid=1&auth_version=1&from=audit&ts=1641279963&md5sum=9a19 404\n\nffplay http://audit-pull-ws.inke.cn/live/1641277798709796.flv\\?msUid\\=1\\&auth_version\\=1\\&from\\=audit\\&ts\\=1641279963\\&md5sum\\=9a19 成功\n```\n\n\n\n直播的推流地址本来就不能回放，但是冷存回复就没问题，能正常播放\n\n\n\n<img src=\"https://raw.githubusercontent.com/xzMhehe/StaticFile_CDN/main/static/mo/20220104161251.png\"/>\n\n\n\n<img src=\"https://raw.githubusercontent.com/xzMhehe/StaticFile_CDN/main/static/mo/20220104161454.png\"/>\n\n\n\n\n\n```bash\n冷存恢复\n\ncurl \"http://tx3-media-cls-config01.bj:6789/api/v1/CosToOss?type=test&live_id=1641277798709796\"\n{\"error_code\":-2,\"error_msg\":\"no m3u8 in object\",\"response\":\"maybe the live broadcast not over\"}#\n\n\n\n ✘ ⚡ root@ali-c-media-control01  ~   curl \"http://tx3-media-cls-config01.bj:6789/api/v1/CosToOss?type=test&live_id=1641277798709796\"\n{\"error_code\":0,\"error_msg\":\"5~10min后尝试播放; 当前时间:2022-01-04 15:57:41\",\"response\":\"http://inke-test-record02.oss-cn-beijing.aliyuncs.com/vod/1641277798709796/1641277798709796.m3u8\"}#\n\n是能够播放的\n```\n\n\n\n\n\n\n\ntest_eryiyi_15622185\n\n\n\n```bash\nIMG_CHECK_ERYIYI_1641266008144187 这个就可以\nhttps://testaudit.me.inke.cn/check/live-check/detail?live_id=1641266008144187&config_id=28&from=now_live\n\n\nIMG_CHECK_ERYIYI_1640953146934463\nhttps://testaudit.me.inke.cn/check/live-check/detail?live_id=test_eryiyi_15622185&config_id=28&from=now_live\n```\n\n正确的日志\n\n```bash\n[work@ali-e-media-testqa04 eryiyi]$ cat eryiyi-common-2022010411.log | grep 1641266008144187\n2022-01-04 11:13:29.730 runtime/asm_amd64.s:1357 INFO ScreenShotManager reading info from chan &{0xc0001e0780 eryiyi 0001-01-01 00:00:00 +0000 UTC 1641266008144187_0  } true\n2022-01-04 11:13:29.730 screenshot/screenshotmanager.go:283 INFO [SCREENSHOT LIVEID LIFE INFO 1641266008144187]start exec cmd: ./bin/mp4_2_jpeg logs/eryiyi http://qq.orig.internal.inke.cn/bujiu-record-pull/live/1641266008144187_0.flv?msUid=screenshot /a8root/work/data/media.operimg.screenshotworker/eryiyi/46/1641266008144187 256 448 4000 -o\n## 它这块也没查到这个\n2022-01-04 11:13:29.732 screenshot/screenshotmanager.go:283 ERROR ScreenShot Start Hget err redigo: nil returned 1641266008144187\n2022-01-04 11:13:29.732 screenshot/screenshot.go:235 INFO ScreenShot taskStatusMonitor key :IMG_CHECK_ERYIYI_1641266008144187 40\n2022-01-04 11:13:49.732 screenshot/screenshot.go:398 INFO ScreenShot taskStatusMonitor imgcheck:{\"taskid\":\"1641266008144187\",\"jepgnums\":4,\"bucketname\":\"inke-test-record\",\"region\":\"ap-beijing\",\"appid\":\"1252926420\",\"timestamp\":1641266027,\"endpoint\":\"s3.inke.srv\"} 1641266008144187\n2022-01-04 11:14:09.733 screenshot/screenshot.go:385 INFO ScreenShot taskStatusMonitor imgcheck:{\"taskid\":\"1641266008144187\",\"jepgnums\":9,\"bucketname\":\"inke-test-record\",\"region\":\"ap-beijing\",\"appid\":\"1252926420\",\"timestamp\":1641266047,\"endpoint\":\"s3.inke.srv\"} 1641266008144187\n2022-01-04 11:14:09.733 screenshot/screenshot.go:398 INFO ScreenShot taskStatusMonitor imgcheck:{\"taskid\":\"1641266008144187\",\"jepgnums\":9,\"bucketname\":\"inke-test-record\",\"region\":\"ap-beijing\",\"appid\":\"1252926420\",\"timestamp\":1641266047,\"endpoint\":\"s3.inke.srv\"} 1641266008144187\n2022-01-04 11:14:11.293 runtime/asm_amd64.s:1357 INFO ScreenShotManager reading info from chan &{0xc0000ca3c0 eryiyi 0001-01-01 00:00:00 +0000 UTC 1641266008144187_0  } true\n2022-01-04 11:14:11.293 screenshot/screenshotmanager.go:292 INFO [SCREENSHOT LIVEID LIFE INFO 1641266008144187]ScreenShot is stopped.\n2022-01-04 11:14:11.293 runtime/asm_amd64.s:1357 INFO [SCREENSHOT LIVEID LIFE INFO 1641266008144187]============= Screenshot Time outcontext canceled\n2022-01-04 11:14:11.293 screenshot/screenshot.go:230 INFO [SCREENSHOT LIVEID LIFE INFO 1641266008144187]============= Screenshot process is killed successfully.\n2022-01-04 11:14:11.293 runtime/asm_amd64.s:1357 INFO ScreenShot taskStatusMonitor exit 1641266008144187\n2022-01-04 11:14:15.302 runtime/asm_amd64.s:1357 INFO [SCREENSHOT LIVEID LIFE INFO 1641266008144187]ScreenShot process is done exit status 56\n2022-01-04 11:14:15.302 runtime/asm_amd64.s:1357 INFO [SCREENSHOT LIVEID LIFE INFO 1641266008144187]ScreenShot process is quit is %!s(MISSING)\n2022-01-04 11:14:15.302 screenshot/screenshotmanager.go:343 INFO [SCREENSHOT LIVEID LIFE INFO 1641266008144187]ScreenShot is stopped.\n```\n\n\n\n\n\n\n\n```bash\n2022-01-04 15:28:10.513 manager/audit.go:39 DEBUG GetAuditStreamAddr url=/live/get/multiaddr?app=eryiyi&from=audit&uid=1, body={\"id\":\"1641277798709796\",\"publish_url\":[\"krns://push.cls.eryiyi/live/1641277798709796?ikProfile=3\\u0026ikWidth=720\\u0026ikHeight=1280\\u0026ikBr=1800\\u0026ikFps=15\\u0026ikMaxBr=1800\\u0026ikMinBr=800\\u0026ikLog=1\\u0026ikKnSlot=0\\u0026ikFEC=3\\u0026ikAACBitrate=64000\\u0026uid=1320620\\u0026ikBeauty=1\\u0026ikKnDebug=2\\u0026ikEnableDRC=0\\u0026ikExposure=0\\u0026ikFilter=1\\u0026dd_type=0\\u0026ikDisableFaceSei=1\\u0026ikLiveType=eryiyi_normal\\u0026clsInfo=eryiyi_normal\\u0026ikTrans=100\\u0026ikTransGrade=4\\u0026ikEnableHD=1\\u0026ikKnClsSecondOpen=1\\u0026ikHevc=1\"]}, resp={\"dm_error\":0,\"error_msg\":\"操作成功\",\"id\":\"1641277798709796\",\"mix_stream_addr\":\"\",\"backup_mix_stream_addr\":\"\",\"multi_stream_addr\":[\"http://audit-pull-ws.inke.cn/live/1641277798709796_0_en.flv?msUid=1&auth_version=1&from=audit&ts=1641281290&md5sum=2fdc\"],\"backup_multi_stream_addr\":[\"http://audit-pull-al.inke.cn/live/1641277798709796_0_en.flv?msUid=1&auth_version=1&from=audit&ts=1641281290&md5sum=2fdc\"]}\n```\n\n\n\n\n\n\n\n最终原因：\n\n<img src=\"https://raw.githubusercontent.com/xzMhehe/StaticFile_CDN/main/static/mo/20220104183624.png\" width=\"500\"/>\n\n不好搞，这个转码流测试环境一直没有\n\n你跟他们说测试环境要支持，得再排期搞\n\n那为啥他的账号可以\n\n不推265就没问题\n\n265，原流也可以\n\n\n\n\n\n## seeklove 觅缘\n\n麦位详情\n\n详情看代理服务接口设计\n\n他们那面打算\n\n```bash\n现在这个接口不是批量查找的么？修改成返回单条的数据可以么？\n```\n\n<img src=\"https://raw.githubusercontent.com/xzMhehe/StaticFile_CDN/main/static/mo/20220104140801.png\"/>\n\n\n\n我是发现大部分业务都是传一个的，他们说`我这边看有最多查询40条的`\n\n下面是业务方给的，还是有好多传多个的\n\n> 我这边看很多请求都是批量查询的，倒是请求单条的比较少\n\n<img src=\"https://raw.githubusercontent.com/xzMhehe/StaticFile_CDN/main/static/mo/20220104184349.png\"/>\n\n\n\n涉及服务太多，就不需要改了\n\n\n\n# 1.5（周三）\n\n## 审核接入测试\n\n### 待规划\n\n\n\n\n\n## 录播 server\n\n不是work\n\n### 陌亲录播播放失败（应该改为音频播放失败）\n\n \n\n```bash\n问题：\n\n2108910460000022826-1082565\n\ncat lovemeet-2022010420.log | grep \'2108910460000022826\'\n\ncat lovemeet-2022010420.log | grep \'2108910460000022826-1082565\'\n\n\nhttps://record.lexiuhuyu.com/record_2108910460000022826-1082565/2108910460000022826-1082565.m3u8\n\n\n\n\n# 排查过程\ncurl \"http://tx3-media-cls-config01.bj:6789/api/v1/CosToOss?type=online&live_id=2035930850000012067-5496267\"\n\n\n\nhttp://record2.inke.cn/record_2035930850000012067/2035930850000012067-5496267.m3u8\n\n\n```\n\n\n\n```bash\n涉及服务器\n[work@tx7-media-stream-live-new27 ~]$ curl cip.cc\nIP	: 49.7.71.32\n地址	: 中国  北京\n运营商	: 电信\n\n数据二	: 北京市 | 腾讯云\n\n数据三	: 中国北京北京 | 电信\n\nURL	: http://www.cip.cc/49.7.71.32\n```\n\n\n\n\n\n<img src=\"https://raw.githubusercontent.com/xzMhehe/StaticFile_CDN/main/static/mo/20220105155852.png\"/>\n\n搞错了。。。。。\n\nKabana\n\n```bash\nhttp://c2-media-mix02.bj:9900/app/kibana#/discover?_g=h@91bd11d&_a=h@a9c9254\n```\n\n\n\n<img src=\"https://raw.githubusercontent.com/xzMhehe/StaticFile_CDN/main/static/mo/20220105161751.png\" width=\"800\"/>\n\n\n\n这不是写着哪台服务器。。。 \n\ninfo.record_task_info.task_host_name: tx5-media-stream-live-new40.bj\n\n\n\n问的机构：\n\n```bash\n@技术支持～训建@zego \nid: s-mlinks3_1-2108910460000022826\n时间范围：January 4th 2022, 20:50:47.000～January 4th 2022, 20:51:50.000\n问题：拉这个流没有拉到？转推到我们源站是否正常？\nip：49.7.71.32 不是这个是tx5-media-stream-live-new40.bj 它的 ： 49.7.106.231\n```\n\n\n\n\n\n它的冷存恢复是这样的 用的他们的id\n\n```bash\ncurl \"http://tx3-media-cls-config01.bj:6789/api/v1/CosToOss?type=test&live_id=s-mlinks3_1-2108910460000022826\"\n```\n\n\n\n```bash\n ✘ ⚡ root@ali-c-media-control01  ~  curl \"http://tx3-media-cls-config01.bj:6789/api/v1/CosToOss?type=test&live_i\n=s-mlinks3_1-2108910460000022826\"\n{\"error_code\":0,\"error_msg\":\"5~10min后尝试播放; 当前时间:2022-01-05 16:56:18\",\"response\":\"http://inke-test-record02.oss-cn-beijing.aliyuncs.com/vod/s-mlinks3_1-2108910460000022826/s-mlinks3_1-2108910460000022826.m3u8\"}#\n```\n\n\n\n\n\n```bash\nffplay http://inke-test-record02.oss-cn-beijing.aliyuncs.com/vod/s-mlinks3_1-2108910460000022826/s-mlinks3_1-2108910460000022826.m3u8\n```\n\n没问题\n\n\n\n等下。。他是 `1v1语音`。。。\n\n```bash\nhttps://record.lexiuhuyu.com/record_2109646840000012156-5638088/feed_2109646840000012156-5638088.m3u8\nhttps://record.lexiuhuyu.com/record_2109646840000012156-9032156/feed_2109646840000012156-9032156.m3u8\nhttps://record.lexiuhuyu.com/record_2109646590000013762-8823762/feed_2109646590000013762-8823762.m3u8\nhttps://record.lexiuhuyu.com/record_2109646590000013762-7401296/feed_2109646590000013762-7401296.m3u8\nhttps://record.lexiuhuyu.com/record_2109644350000012172-6802444/2109644350000012172-6802444.m3u8\nhttps://record.lexiuhuyu.com/record_2109644350000012172-8802172/2109644350000012172-8802172.m3u8\n```\n\n\n\n```bash\nhttps://audit.inke.cn/play/video_player.php?type=flash&width=270&height=380&playbackrate=1&url=https://record.lexiuhuyu.com/record_2109646840000012156-5638088/feed_2109646840000012156-5638088.m3u8\n\nhttps://audit.inke.cn/play/video_player.php?type=flash&width=270&height=380&playbackrate=1&url=https://record.lexiuhuyu.com/record_2109646840000012156-9032156/feed_2109646840000012156-9032156.m3u8\n\nhttps://audit.inke.cn/play/video_player.php?type=flash&width=270&height=380&playbackrate=1&url=https://record.lexiuhuyu.com/record_2109646590000013762-8823762/feed_2109646590000013762-8823762.m3u8\n\nhttps://audit.inke.cn/play/video_player.php?type=flash&width=270&height=380&playbackrate=1&url=https://record.lexiuhuyu.com/record_2109646590000013762-7401296/feed_2109646590000013762-7401296.m3u8\n\nhttps://audit.inke.cn/play/video_player.php?type=flash&width=270&height=380&playbackrate=1&url=https://record.lexiuhuyu.com/record_2109644350000012172-6802444/2109644350000012172-6802444.m3u8\n\nhttps://audit.inke.cn/play/video_player.php?type=flash&width=270&height=380&playbackrate=1&url=https://record.lexiuhuyu.com/record_2109644350000012172-8802172/2109644350000012172-8802172.m3u8\n```\n\n\n\n\n\n\n\n使用ffmpeg下载m3u8，保存MP4或MP3方法记录\n\n直接下载MP4\n\n```bash\nffmpeg -i  \"http://xxxxxx.com/xxxx.m3u8\" -vcodec copy -acodec copy -absf aac_adtstoasc output.mp4\n```\n\n下载MP3\n\n```bash\nffmpeg -i \"http://iaa.flashmediacast.com:2387/live//radio-93-3/playlist.m3u8\" -acodec mp3 -ab 257k radio.mp3\n```\n\n\n\n判断播放器问题\n\n\n\n## 缩放图\n\n### 规则添加\n\n[@马鑫泽](#)  统计里一波，这些对应关系目前没有配置，腾讯集群迁移的话，这个需要配置一下\n\n```bash\nimg.taikongxingyuan.com         xingyuan-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.hongfengte.com              vivahuo-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.hnyingyu.com                lovemeet-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.caratbj.com                 meetstar-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.meetcplive.com              meetstar-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.starstarlive.com            inpa-image.oss-cn-beijing.aliyuncs.com\nimg.hmqiansheng.com             seeklove-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.misslooker.com              silian-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.xinjumeet.com               meetstar-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.vipfengyun.com              seeklove-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.hunanqiufen.cn              blackcat-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.okfengyun.com               seeklove-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.lexiu888.com                lovemeet-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.taoyuhn.cn                  shengquan-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.hntaoyu.cn                  shengquan-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.lexiuwangluo.com            lovemeet-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.qianshenghm.com             tianmi-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.hainanliyou.com             deep-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.liyouhainan.com             deep-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.qianshenghn.cn              seeklove-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.tmqiansheng.com             seeklove-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.xinjulove.com               lovemeet-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.miyuehn.com                 deep-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.miyueyl.com                 deep-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.fatehn.com                  deep-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.fateyl.com                  deep-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.ssfunplay.com               yochat-img-1252926420.cos.ap-singapore.myqcloud.com\nimg.soundclublive.com           yinpao-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.zhishichaoren.com           localmeet-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.caratbj.com                 meetstar-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.zhishichaoren.cn            yinpao-media-1252926420.cos.ap-beijing.myqcloud.com\nimg.hnhongya.cn                 localmeet-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.hainanhongya.cn             localmeet-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.hnbuylive.com               dock-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.yibaihk.cn                  eryiyi-img-1252926420.cos.ap-beijing.myqcloud.com \nimg.yltchongya.cn               localmeet-img-1252926420.cos.ap-beijing.myqcloud.com\nimg.hyhongya.cn                 localmeet-img-1252926420.cos.ap-beijing.myqcloud.com\n```\n\n\n\n\n\n\n\n# 1.6（周四）\n\n## 审核接入\n\n```bash\n原截图接口\n\ncurl \'http://testqa.apigateway.inkept.cn/api/media/comm_service/room_change\' -d \'{\"app_name\":\"test6\",\"live_type\":\"1v1_live\",\"broadcast\":\"start\",\"event\":\"publish\",\"media_type\":\"video\",\"liveid\":\"audit_test_15622185\",\"uid\":12949485,\"dis_slot\":0,\"slot\":0,\"creator_uid\":12949485,\"publish_addr\":null,\"stream_addr\":\"https://nights.tx.play.eyouwx.com/live/14043423_11659164.flv?txSecret=abd49e94fb54a2d4ac692661a3d37907&txTime=61B85550\",\"stream_type\":\"1\",\"multi_object_id\":\"audit_test_15622185-12949485\",\"mix_object_id\":null,\"asr_text_callback_url\":null,\"source\":\"audit\",\"shot_type\":\"1\",\"audit_shot_cfg\":{\"pic_width\":\"720\",\"pic_high\":\"1280\",\"screenshot_interval\":2}}\'\n```\n\n\n\n\n\n\n\n```bash\nhttp://play-aliyun.yingtaorelian.com/yingtaorelian/160696422696400107-1641519146.flv\nhttp://play-aliyun.yingtaorelian.com/yingtaorelian/160696422696400107-1641519146_2_30208551_2.flv\n\ncurl \'http://127.0.0.1:15248/api/v1/start_task\' -d \'{\"Appname\":\"test4\",\"live_type\":\"1v1_live\",\"broadcast\":\"start\",\"event\":\"publish\",\"media_type\":\"video\",\"liveid\":\"audit_test_15622186\",\"uid\":12949485,\"dis_slot\":0,\"slot\":0,\"creator_uid\":12949485,\"publish_addr\":null,\"stream_addr\":\"http://play-aliyun.yingtaorelian.com/yingtaorelian/160696422696400107-1641519146.flv?txSecret=abd49e94fb54a2d4ac692661a3d37907&txTime=61B85550\",\"stream_type\":\"1\",\"multi_object_id\":\"audit_test_15622185-12949485\",\"mix_object_id\":null,\"asr_text_callback_url\":null}\'\n\n\n\ncurl \'http://127.0.0.1:15248/api/v1/stop_task\' -d \'{\"Appname\":\"test4\",\"live_type\":\"1v1_live\",\"broadcast\":\"stop\",\"event\":\"unpublish\",\"media_type\":\"video\",\"liveid\":\"audit_test_15622186\",\"uid\":12949485,\"dis_slot\":0,\"slot\":0,\"creator_uid\":12949485,\"publish_addr\":null,\"stream_addr\":\"http://play-aliyun.yingtaorelian.com/yingtaorelian/160696422696400107-1641519146.flv?txSecret=abd49e94fb54a2d4ac692661a3d37907&txTime=61B85550\",\"stream_type\":\"1\",\"multi_object_id\":\"audit_test_15622185-12949485\",\"mix_object_id\":null,\"asr_text_callback_url\":null}\'\n```\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n## 缩放图\n\n### 规则添加\n\n```bash\n14 img.starstarlive.com	inpa-image.oss-cn-beijing.aliyuncs.com	inpa-image.s3.inke.srv	冲突文档已划掉 添加75\n删除之前\n\"img.starstarlive.com\": DomainConfig{\n  App:         \"starstar\",\n  S3Domain:    \"inpa-image.s3.inke.srv\",\n  StorageType: OSS,\n},\n\n55	觅缘马甲包-附近情缘	img.vipfengyun.com 未划掉，不做添加 79\n\"img.vipfengyun.com\": DomainConfig{\n  App:            \"seeklove\",\n  S3Domain:       \"seeklove-img-1252926420.s3.inke.srv\",\n  InternalDomain: \"seeklove-img-1252926420.cos.ap-beijing.myqcloud.com\",\n  StorageType:    COS,\n},\n\n\n49	blackcat 剧本杀	img.hunanqiufen.cn media.hunanqiufen.cn 未划掉，不做添加 80\n\n\n73 和99重复 添加73，不做添加99\n\n\n\n总共添加34个\n```\n\n\n\n\n\n## [主板9人房视频团战需求](https://wiki.inkept.cn/pages/viewpage.action?pageId=214306681)\n\n配合进行联调\n\n\n\nappname:inke\nlivetype:residentlive\n\n\n\nqa环境配置\n\n<img src=\"https://raw.githubusercontent.com/xzMhehe/StaticFile_CDN/main/static/mo/20220106141034.png\" width=\"600\"/>\n\n\n\n\n\n\n\n\n\n## 成本结算\n\nmysql数据添加进共享资源\n\n\n\n\n\n\n\n## other\n\n```bash\n常晓栋:\n\n原来的即构视频流地址   \'http://hdl-ws.buylivegame.com/buylivegame/1111.flv\' 修改后的即构视频流地址   \'http://hdl-ws.pokerloverpro.com/pokerloverpro/1111.flv\'@罗俊辉  是这样的一个修改\n\n\n@常晓栋    那就需要调整。什么时候需要调整好？现在线上就已经可以用了吗？\n\n原来的即构视频流地址   \'http://hdl-ws.buylivegame.com/buylivegame/1111.flv\'\n修改后的即构视频流地址   \'http://hdl-ws.pokerloverpro.com/pokerloverpro/1111.flv\'@罗俊辉 \n是这样的一个修改\n```\n\n注意这是海外业务需要去海外的服务器查询相关日志\n\n这边查询了 审核拉流调度服务没有发现，他们的配置，\n\n\n\n然后查询了新加坡的录播截图发现是有拉流地址的\n\n```bash\n截图： http://hdl-ws.buylivegame.com/buylivegame/71716989.flv\n```\n\n录播也是有的\n\n又去了新加坡的代理,也是有的，说明确实是他们传过来的，不需要我们这边对配置进行修改\n\n```bash\n2022-01-06 17:16:20.568 server/server_handle.go:115 INFO SentRoomChangInfo2Server sent succ! resp:{\"error_code\":0,\"error_msg\":\"\",\"response\":\"success\"}, err:%!s(<nil>), serverName:media.disp.screenshot, path:/api/v1/room_change, appname:pokershark, livetype:normal-link, liveid:387735|13983183,slot:0, uid:13983183, event:unpublish, broadcast:start, sentTimes:1, body:{\"app_name\":\"pokershark\",\"live_type\":\"normal-link\",\"broadcast\":\"start\",\"event\":\"unpublish\",\"media_type\":\"video\",\"liveid\":\"387735|13983183\",\"uid\":13983183,\"creator_uid\":13983183,\"slot\":0,\"dis_slot\":0,\"publish_addr\":\"\",\"stream_addr\":\"http://hdl-ws.buylivegame.com/buylivegame/13983183.flv\",\"stream_type\":\"1\",\"mix_stream_addr\":\"\",\"asr_stream_addr\":\"\",\"multi_object_id\":\"\",\"mix_object_id\":\"\",\"asr_text_callback_url\":\"\",\"start_time\":1641460498,\"update_time\":1641460580}\n```\n\n\n\n\n\n# 1.7（周五）\n\n## 审核接入\n\n```bash\nhttp://play-aliyun.yingtaorelian.com/yingtaorelian/163829046272260102-1641524113.flv\nhttp://play-aliyun.yingtaorelian.com/yingtaorelian/163829046272260102-1641524113_1_40684420_1.flv\n\nhttp://play-aliyun.yingtaorelian.com/yingtaorelian/161814221681660103-1644535572.flv\n\ncurl \'http://127.0.0.1:15248/api/v1/start_task\' -d \'{\"Appname\":\"test\",\"live_type\":\"onebyone\",\"broadcast\":\"start\",\"event\":\"publish\",\"media_type\":\"video\",\"liveid\":\"audit_test_15622186\",\"uid\":12949485,\"dis_slot\":0,\"slot\":0,\"creator_uid\":12949485,\"publish_addr\":null,\"stream_addr\":\"http://play-aliyun.yingtaorelian.com/yingtaorelian/163829046272260102-1641524113.flv?txSecret=abd49e94fb54a2d4ac692661a3d37907&txTime=61B85550\",\"stream_type\":\"1\",\"multi_object_id\":\"audit_test_15622185-12949485\",\"mix_object_id\":null,\"asr_text_callback_url\":null}\'\n\n\n\ncurl \'http://127.0.0.1:15248/api/v1/stop_task\' -d \'{\"Appname\":\"test6\",\"live_type\":\"onebyone\",\"broadcast\":\"stop\",\"event\":\"unpublish\",\"media_type\":\"video\",\"liveid\":\"audit_test_15622186\",\"uid\":12949485,\"dis_slot\":0,\"slot\":0,\"creator_uid\":12949485,\"publish_addr\":null,\"stream_addr\":\"http://play-aliyun.yingtaorelian.com/yingtaorelian/160696422696400107-1641519146.flv?txSecret=abd49e94fb54a2d4ac692661a3d37907&txTime=61B85550\",\"stream_type\":\"1\",\"multi_object_id\":\"audit_test_15622185-12949485\",\"mix_object_id\":null,\"asr_text_callback_url\":null}\'\n```\n\n\n\n\n\n<img src=\"https://raw.githubusercontent.com/xzMhehe/StaticFile_CDN/main/static/mo/20220107164320.png\"/>\n\n\n\n把日志开启后\n\n```bash\n2022-01-07 18:35:46.232 storage/cos_storage.go:63 INFO NewCOSStorage rawurl:%!(EXTRA string=http://inke-test-record-1252926420.test-s3.inke.srv) {\"trace_id\":\"9b6476cd5adda822f5ea0f7f\"}\n2022-01-07 18:35:46.232 storage/cos_storage.go:63 INFO NewCOSStorage rawurl:%!(EXTRA string=http://inke-test-record-1252926420.test-s3.inke.srv) {\"trace_id\":\"9b6476cd5adda822f5ea0f7f\"}\n2022-01-07 18:35:46.233 taskmanager/manager_container.go:46 INFO begin receive event...\n2022-01-07 18:35:46.233 taskmanager/manager_container.go:47 INFO begin receive event...\n2022-01-07 18:35:46.233 storage/cos_storage.go:63 INFO NewCOSStorage rawurl:%!(EXTRA string=http://inke-test-record-1252926420.test-s3.inke.srv) {\"trace_id\":\"9b6476cd5adda822f5ea0f7f\"}\n2022-01-07 18:35:46.242 upload/upload.go:177 INFO bRootPath:/a8root/work/data/media.record.flv2hlsworker/mido/\n2022-01-07 18:35:46.243 realization/task_mgr.go:42 INFO Start get task from channel\n2022-01-07 18:35:46.243 upload/upload.go:177 INFO bRootPath:/a8root/work/data/media.record.flv2hlsworker/artemis/\n2022-01-07 18:35:46.248 upload/upload.go:177 INFO bRootPath:/a8root/work/data/media.record.flv2hlsworker/yap/\n2022-01-07 18:35:46.313 upload/upload.go:177 INFO bRootPath:/a8root/work/data/media.record.flv2hlsworker/ssplanet/\n2022-01-07 18:35:46.360 upload/upload.go:177 INFO bRootPath:/a8root/work/data/media.record.flv2hlsworker/eryiyi/\n2022-01-07 18:35:46.369 upload/upload.go:177 INFO bRootPath:/a8root/work/data/media.record.flv2hlsworker/tianmi/\n2022-01-07 18:35:46.373 upload/upload.go:177 INFO bRootPath:/a8root/work/data/media.record.flv2hlsworker/blackcat/\n2022-01-07 18:35:46.378 upload/upload.go:177 INFO bRootPath:/a8root/work/data/media.record.flv2hlsworker/silian/\n2022-01-07 18:35:47.243 realization/task_mgr.go:48 INFO chan len 0\n```\n\n\n\n\n\n\n\n## [主板9人房视频团战需求](https://wiki.inkept.cn/pages/viewpage.action?pageId=214306681)\n\n配合进行联调\n\n```bash\nali-qa-k8s-inke-media-common-proxy16\n```\n\n\n\n日志排查\n\n解析的数据\n\n```bash\n{\"app_name\":\"inke\",\"live_type\":\"residentlive\",\"broadcast\":\"start\",\"event\":\"publish\",\"media_type\":\"video\",\"liveid\":\"1641521391640813\",\"uid\":700010274,\"slot\":1,\"creator_uid\":0,\"shot_type\":\"2\",\"audit_shot_cfg\":{\"pic_width\":\"720\",\"pic_high\":\"1080\",\"screenshot_interval\":2}}\n```\n\n缺少推流地址\n\n```bash\n这个不是由多媒体维护吗\n周期全量在线房间消息也上qa了\n走的不是标准化的sdk，所以是需要传的\n```\n\n\n\n```bash\n2022-01-07 10:10:01.006 server/server_handle.go:463 ERROR CheckRepetitionTask get liveid task not exist! appname:inke, livetype:residentlive, liveid:1641521391640813,slot:1, uid:700010274, event:publish, broadcast:start {\"trace_id\":\"88ad53955ad63f8c12dd3ca0\",\"namespace\":\"inke\"}\n2022-01-07 10:10:01.008 server/server.go:499 ERROR QueryPublishAddr2URL fail! serverName:media.agent.usermessage, url:http://10.128.0.19:10010/uma/live/info?appName=inke&liveid=1641521391640813&uid=700010274,err:<nil>, publishAddr:, appname:inke, livetype:residentlive, liveid:1641521391640813,slot:1, uid:700010274, event:publish, broadcast:start, count:1 {\"trace_id\":\"88ad53955ad63f8c12dd3ca0\",\"namespace\":\"inke\"}\n2022-01-07 10:10:01.510 server/server.go:499 ERROR QueryPublishAddr2URL fail! serverName:media.agent.usermessage, url:http://10.128.0.19:10010/uma/live/info?appName=inke&liveid=1641521391640813&uid=700010274,err:<nil>, publishAddr:, appname:inke, livetype:residentlive, liveid:1641521391640813,slot:1, uid:700010274, event:publish, broadcast:start, count:2 {\"trace_id\":\"88ad53955ad63f8c12dd3ca0\",\"namespace\":\"inke\"}\n2022-01-07 10:10:02.012 server/server.go:499 ERROR QueryPublishAddr2URL fail! serverName:media.agent.usermessage, url:http://10.128.0.19:10010/uma/live/info?appName=inke&liveid=1641521391640813&uid=700010274,err:<nil>, publishAddr:, appname:inke, livetype:residentlive, liveid:1641521391640813,slot:1, uid:700010274, event:publish, broadcast:start, count:3 {\"trace_id\":\"88ad53955ad63f8c12dd3ca0\",\"namespace\":\"inke\"}\n2022-01-07 10:10:02.512 server/server.go:416 ERROR GetPublishAddrAndStreamAddr QueryUMA2PublishAddr err:query from uma fail! umaURL:http://10.128.0.19:10010/uma/live/info?appName=inke&liveid=1641521391640813&uid=700010274, appname:inke, livetype:residentlive, liveid:1641521391640813,slot:1, uid:700010274, event:publish, broadcast:start {\"trace_id\":\"88ad53955ad63f8c12dd3ca0\",\"namespace\":\"inke\"}\n2022-01-07 10:10:02.512 server/server.go:395 ERROR QueryAddr fail! publish_addr:, stream_addr:[], asrStreamAddr:[], err:query from uma fail! umaURL:http://10.128.0.19:10010/uma/live/info?appName=inke&liveid=1641521391640813&uid=700010274, appname:inke, livetype:residentlive, liveid:1641521391640813,slot:1, uid:700010274, event:publish, broadcast:start, appname:inke, livetype:residentlive, liveid:1641521391640813,slot:1, uid:700010274, event:publish, broadcast:start {\"trace_id\":\"88ad53955ad63f8c12dd3ca0\",\"namespace\":\"inke\"}\n```\n\n\n\n\n\n\n\n\n\n业务方配置万后\n\n错误日志\n\n```bash\n2022-01-07 11:20:05.710 server/server_handle.go:463 ERROR CheckRepetitionTask get liveid task not exist! appname:inke, livetype:residentlive, liveid:1641525592879009,slot:1, uid:700010274, event:publish, broadcast:start {\"trace_id\":\"88ad53955ad7465c9d6eed8a\",\"namespace\":\"inke\"}\n2022-01-07 11:20:05.710 http/router.go:292 INFO RoomChange write succ! appname:inke, livetype:residentlive, liveid:1641525592879009,slot:1, uid:700010274, event:publish, broadcast:start {\"trace_id\":\"88ad53955ad7465c9d6eed8a\",\"namespace\":\"inke\"}\n2022-01-07 11:20:05.710 server/server.go:426 INFO GetPublishAddrAndStreamAddr publishAddr:http://temp.zigo.link.inke.cn/publish/trans/inkeaudio/mlinkm/1641525592879009?ikPath=1&ikFWUrl=rtmp%3A%2F%2Fqqaudio.push.inke.cn%2Flive%2F%7Bliveid%7D%3Fsign%3Dff0e6ec485f0689eMjAwLXFxYXVkaW8ucHVzaC5pbmtlLmNuLTcwMDAxMDI3NA%253D%253D%26ver%3D2&ikLog=1&ikSoftAACLev=2&ikAACBitrate=64000&uid=700010274&ikBeauty=1&ikKnDebug=2&ikEnableDRC=0&ikExposure=0&ikFilter=1&dd_type=0&ikDisableFaceSei=1&ikKnIncr=0&ikLiveType=residentlive&ikFaceMorph=1&ikNewProcess=1&ikSeven=1, appname:inke, livetype:residentlive, liveid:1641525592879009,slot:1, uid:700010274, event:publish, broadcast:start {\"trace_id\":\"88ad53955ad7465c9d6eed8a\",\"namespace\":\"inke\"}\n2022-01-07 11:20:05.714 server/server.go:537 ERROR GetStreamAddr2Recorder fail! url:http://testqa.apigateway.inkept.cn/live/get/multiaddr?app=inke&from=record, publishAddr:http://temp.zigo.link.inke.cn/publish/trans/inkeaudio/mlinkm/1641525592879009?ikPath=1&ikFWUrl=rtmp%3A%2F%2Fqqaudio.push.inke.cn%2Flive%2F%7Bliveid%7D%3Fsign%3Dff0e6ec485f0689eMjAwLXFxYXVkaW8ucHVzaC5pbmtlLmNuLTcwMDAxMDI3NA%253D%253D%26ver%3D2&ikLog=1&ikSoftAACLev=2&ikAACBitrate=64000&uid=700010274&ikBeauty=1&ikKnDebug=2&ikEnableDRC=0&ikExposure=0&ikFilter=1&dd_type=0&ikDisableFaceSei=1&ikKnIncr=0&ikLiveType=residentlive&ikFaceMorph=1&ikNewProcess=1&ikSeven=1, len(MultiAddr)=0, count:1, appname:inke, livetype:residentlive, liveid:1641525592879009,slot:1, uid:700010274, event:publish, broadcast:start {\"trace_id\":\"88ad53955ad7465c9d6eed8a\",\"namespace\":\"inke\"}\n2022-01-07 11:20:05.872 server/server.go:537 ERROR GetStreamAddr2Recorder fail! url:http://testqa.apigateway.inkept.cn/live/get/multiaddr?app=inke&from=record, publishAddr:http://temp.zigo.link.inke.cn/publish/trans/inkeaudio/mlinkm/1641525592879009?ikPath=1&ikFWUrl=rtmp%3A%2F%2Fqqaudio.push.inke.cn%2Flive%2F%7Bliveid%7D%3Fsign%3Dff0e6ec485f0689eMjAwLXFxYXVkaW8ucHVzaC5pbmtlLmNuLTcwMDAxMDI3NA%253D%253D%26ver%3D2&ikLog=1&ikSoftAACLev=2&ikAACBitrate=64000&uid=700010274&ikBeauty=1&ikKnDebug=2&ikEnableDRC=0&ikExposure=0&ikFilter=1&dd_type=0&ikDisableFaceSei=1&ikKnIncr=0&ikLiveType=residentlive&ikFaceMorph=1&ikNewProcess=1&ikSeven=1, len(MultiAddr)=0, count:2, appname:inke, livetype:residentlive, liveid:1641525592879009,slot:1, uid:700010274, event:publish, broadcast:start {\"trace_id\":\"88ad53955ad7465c9d6eed8a\",\"namespace\":\"inke\"}\n2022-01-07 11:20:05.975 server/server.go:537 ERROR GetStreamAddr2Recorder fail! url:http://testqa.apigateway.inkept.cn/live/get/multiaddr?app=inke&from=record, publishAddr:http://temp.zigo.link.inke.cn/publish/trans/inkeaudio/mlinkm/1641525592879009?ikPath=1&ikFWUrl=rtmp%3A%2F%2Fqqaudio.push.inke.cn%2Flive%2F%7Bliveid%7D%3Fsign%3Dff0e6ec485f0689eMjAwLXFxYXVkaW8ucHVzaC5pbmtlLmNuLTcwMDAxMDI3NA%253D%253D%26ver%3D2&ikLog=1&ikSoftAACLev=2&ikAACBitrate=64000&uid=700010274&ikBeauty=1&ikKnDebug=2&ikEnableDRC=0&ikExposure=0&ikFilter=1&dd_type=0&ikDisableFaceSei=1&ikKnIncr=0&ikLiveType=residentlive&ikFaceMorph=1&ikNewProcess=1&ikSeven=1, len(MultiAddr)=0, count:3, appname:inke, livetype:residentlive, liveid:1641525592879009,slot:1, uid:700010274, event:publish, broadcast:start {\"trace_id\":\"88ad53955ad7465c9d6eed8a\",\"namespace\":\"inke\"}\n2022-01-07 11:20:06.079 server/server.go:433 ERROR GetPublishAddrAndStreamAddr fail! streamAddr is nil. asrStreamAddr not nil! err:query 2 recorder fail! url:http://testqa.apigateway.inkept.cn/live/get/multiaddr?app=inke&from=record, publishAddr:http://temp.zigo.link.inke.cn/publish/trans/inkeaudio/mlinkm/1641525592879009?ikPath=1&ikFWUrl=rtmp%3A%2F%2Fqqaudio.push.inke.cn%2Flive%2F%7Bliveid%7D%3Fsign%3Dff0e6ec485f0689eMjAwLXFxYXVkaW8ucHVzaC5pbmtlLmNuLTcwMDAxMDI3NA%253D%253D%26ver%3D2&ikLog=1&ikSoftAACLev=2&ikAACBitrate=64000&uid=700010274&ikBeauty=1&ikKnDebug=2&ikEnableDRC=0&ikExposure=0&ikFilter=1&dd_type=0&ikDisableFaceSei=1&ikKnIncr=0&ikLiveType=residentlive&ikFaceMorph=1&ikNewProcess=1&ikSeven=1, appname:inke, livetype:residentlive, liveid:1641525592879009,slot:1, uid:700010274, event:publish, broadcast:start, appname:inke, livetype:residentlive, liveid:1641525592879009,slot:1, uid:700010274, event:publish, broadcast:start {\"trace_id\":\"88ad53955ad7465c9d6eed8a\",\"namespace\":\"inke\"}\n2022-01-07 11:20:06.079 server/server.go:395 ERROR QueryAddr fail! publish_addr:http://temp.zigo.link.inke.cn/publish/trans/inkeaudio/mlinkm/1641525592879009?ikPath=1&ikFWUrl=rtmp%3A%2F%2Fqqaudio.push.inke.cn%2Flive%2F%7Bliveid%7D%3Fsign%3Dff0e6ec485f0689eMjAwLXFxYXVkaW8ucHVzaC5pbmtlLmNuLTcwMDAxMDI3NA%253D%253D%26ver%3D2&ikLog=1&ikSoftAACLev=2&ikAACBitrate=64000&uid=700010274&ikBeauty=1&ikKnDebug=2&ikEnableDRC=0&ikExposure=0&ikFilter=1&dd_type=0&ikDisableFaceSei=1&ikKnIncr=0&ikLiveType=residentlive&ikFaceMorph=1&ikNewProcess=1&ikSeven=1, stream_addr:[], asrStreamAddr:[], err:query 2 recorder fail! url:http://testqa.apigateway.inkept.cn/live/get/multiaddr?app=inke&from=record, publishAddr:http://temp.zigo.link.inke.cn/publish/trans/inkeaudio/mlinkm/1641525592879009?ikPath=1&ikFWUrl=rtmp%3A%2F%2Fqqaudio.push.inke.cn%2Flive%2F%7Bliveid%7D%3Fsign%3Dff0e6ec485f0689eMjAwLXFxYXVkaW8ucHVzaC5pbmtlLmNuLTcwMDAxMDI3NA%253D%253D%26ver%3D2&ikLog=1&ikSoftAACLev=2&ikAACBitrate=64000&uid=700010274&ikBeauty=1&ikKnDebug=2&ikEnableDRC=0&ikExposure=0&ikFilter=1&dd_type=0&ikDisableFaceSei=1&ikKnIncr=0&ikLiveType=residentlive&ikFaceMorph=1&ikNewProcess=1&ikSeven=1, appname:inke, livetype:residentlive, liveid:1641525592879009,slot:1, uid:700010274, event:publish, broadcast:start, appname:inke, livetype:residentlive, liveid:1641525592879009,slot:1, uid:700010274, event:publish, broadcast:start {\"trace_id\":\"88ad53955ad7465c9d6eed8a\",\"namespace\":\"inke\"}\n2022-01-07 11:20:06.079 server/server.go:326 ERROR ActualDealRoomChange QueryAddr query fail! appname:inke, livetype:residentlive, liveid:1641525592879009,slot:1, uid:700010274, event:publish, broadcast:start, err:query 2 recorder fail! url:http://testqa.apigateway.inkept.cn/live/get/multiaddr?app=inke&from=record, publishAddr:http://temp.zigo.link.inke.cn/publish/trans/inkeaudio/mlinkm/1641525592879009?ikPath=1&ikFWUrl=rtmp%3A%2F%2Fqqaudio.push.inke.cn%2Flive%2F%7Bliveid%7D%3Fsign%3Dff0e6ec485f0689eMjAwLXFxYXVkaW8ucHVzaC5pbmtlLmNuLTcwMDAxMDI3NA%253D%253D%26ver%3D2&ikLog=1&ikSoftAACLev=2&ikAACBitrate=64000&uid=700010274&ikBeauty=1&ikKnDebug=2&ikEnableDRC=0&ikExposure=0&ikFilter=1&dd_type=0&ikDisableFaceSei=1&ikKnIncr=0&ikLiveType=residentlive&ikFaceMorph=1&ikNewProcess=1&ikSeven=1, appname:inke, livetype:residentlive, liveid:1641525592879009,slot:1, uid:700010274, event:publish, broadcast:start {\"trace_id\":\"88ad53955ad7465c9d6eed8a\",\"namespace\":\"inke\"}\n2022-01-07 11:20:06.079 monitoring/dingpost.go:81 INFO {\"msgtype\":\"text\",\"text\":{\"content\":\"代理报警——时间：2022-01-07 11:20:06 \\n机器信息：ali-qa-k8s-inke-media-common-proxy16.bj \\n任务信息详细信息如下： \\nappname：inke，livetype：residentlive，liveid：1641525592879009，slot：1，uid：700010274，event：publish \\n推流地址：http://temp.zigo.link.inke.cn/publish/trans/inkeaudio/mlinkm/1641525592879009?ikPath=1\\u0026ikFWUrl=rtmp%3A%2F%2Fqqaudio.push.inke.cn%2Flive%2F%7Bliveid%7D%3Fsign%3Dff0e6ec485f0689eMjAwLXFxYXVkaW8ucHVzaC5pbmtlLmNuLTcwMDAxMDI3NA%253D%253D%26ver%3D2\\u0026ikLog=1\\u0026ikSoftAACLev=2\\u0026ikAACBitrate=64000\\u0026uid=700010274\\u0026ikBeauty=1\\u0026ikKnDebug=2\\u0026ikEnableDRC=0\\u0026ikExposure=0\\u0026ikFilter=1\\u0026dd_type=0\\u0026ikDisableFaceSei=1\\u0026ikKnIncr=0\\u0026ikLiveType=residentlive\\u0026ikFaceMorph=1\\u0026ikNewProcess=1\\u0026ikSeven=1 \\n拉流地址： \\n合流拉流地址： \\n错误信息：query 2 recorder fail! url:http://testqa.apigateway.inkept.cn/live/get/multiaddr?app=inke\\u0026from=record, publishAddr:http://temp.zigo.link.inke.cn/publish/trans/inkeaudio/mlinkm/1641525592879009?ikPath=1\\u0026ikFWUrl=rtmp%3A%2F%2Fqqaudio.push.inke.cn%2Flive%2F%7Bliveid%7D%3Fsign%3Dff0e6ec485f0689eMjAwLXFxYXVkaW8ucHVzaC5pbmtlLmNuLTcwMDAxMDI3NA%253D%253D%26ver%3D2\\u0026ikLog=1\\u0026ikSoftAACLev=2\\u0026ikAACBitrate=64000\\u0026uid=700010274\\u0026ikBeauty=1\\u0026ikKnDebug=2\\u0026ikEnableDRC=0\\u0026ikExposure=0\\u0026ikFilter=1\\u0026dd_type=0\\u0026ikDisableFaceSei=1\\u0026ikKnIncr=0\\u0026ikLiveType=residentlive\\u0026ikFaceMorph=1\\u0026ikNewProcess=1\\u0026ikSeven=1, appname:inke, livetype:residentlive, liveid:1641525592879009,slot:1, uid:700010274, event:publish, broadcast:start\"},\"at\":{\"atMobiles\":null,\"isAtAll\":false}} {\"trace_id\":\"88ad53955ad7465c9d6eed8a\",\"namespace\":\"inke\"}\n2022-01-07 11:20:06.310 http/router.go:278 ERROR DealRoomChange deal fail! err:query 2 recorder fail! url:http://testqa.apigateway.inkept.cn/live/get/multiaddr?app=inke&from=record, publishAddr:http://temp.zigo.link.inke.cn/publish/trans/inkeaudio/mlinkm/1641525592879009?ikPath=1&ikFWUrl=rtmp%3A%2F%2Fqqaudio.push.inke.cn%2Flive%2F%7Bliveid%7D%3Fsign%3Dff0e6ec485f0689eMjAwLXFxYXVkaW8ucHVzaC5pbmtlLmNuLTcwMDAxMDI3NA%253D%253D%26ver%3D2&ikLog=1&ikSoftAACLev=2&ikAACBitrate=64000&uid=700010274&ikBeauty=1&ikKnDebug=2&ikEnableDRC=0&ikExposure=0&ikFilter=1&dd_type=0&ikDisableFaceSei=1&ikKnIncr=0&ikLiveType=residentlive&ikFaceMorph=1&ikNewProcess=1&ikSeven=1, appname:inke, livetype:residentlive, liveid:1641525592879009,slot:1, uid:700010274, event:publish, broadcast:start, appname:inke, livetype:residentlive, liveid:1641525592879009, uid:700010274, event:publish {\"trace_id\":\"88ad53955ad7465c9d6eed8a\",\"namespace\":\"inke\"}\n[maxinze@ali-qa-k8s-inke-media-common-proxy16 logs]$\n```\n\n\n\n<img src=\"https://raw.githubusercontent.com/xzMhehe/StaticFile_CDN/main/static/mo/20220107113351.png\"/>\n\n\n\n```go\nfunc (s *Server) QueryAddr(rcInfo *model.RoomChangeInfo) error {\n  //做下判断\n	if !(rcInfo.App_Name == \"inke\" && rcInfo.LiveType == \"residentlive\") {\n		publishAddr, streamAddResp, asrStreamAddrResp, err := s.GetPublishAddrAndStreamAddr(rcInfo)\n		if err != nil { // err!=nil还需要判断是否有zego合流业务，zego合流只需要推流地址即可\n			if publishAddr != \"\" && s.IsZegoMix(rcInfo) {\n				rcInfo.PublishAddr = publishAddr\n				return nil\n			}\n			log.Errorf(\"QueryAddr fail! publish_addr:%s, stream_addr:%v, asrStreamAddr:%v, err:%s, %s\", publishAddr, streamAddResp.MultiAddr, asrStreamAddrResp.MultiAddr, err, GetRoomInfoLog(rcInfo))\n			return err\n		}\n		log.Infof(\"QueryAddr succ! publish_addr:%s, stream_addr:%v, asrStreamAddr:%v, %s\", publishAddr, streamAddResp.MultiAddr, asrStreamAddrResp.MultiAddr, GetRoomInfoLog(rcInfo))\n\n		rcInfo.PublishAddr = publishAddr\n		if len(streamAddResp.MultiAddr) != 0 {\n			rcInfo.StreamAddr = streamAddResp.MultiAddr[0]\n		}\n		if len(asrStreamAddrResp.MultiAddr) != 0 {\n			rcInfo.AsrStreamAddr = asrStreamAddrResp.MultiAddr[0]\n		}\n		rcInfo.MixStreamAddr = streamAddResp.MixAddr\n	} else {\n		rcInfo.MixStreamAddr = fmt.Sprintf(\"http://qq.orig.internal.inke.cn/inke-record-pull/live/%s.flv\", rcInfo.Liveid)\n	}\n	return nil\n}\n```\n\n\n\n\n\n审核拉流调度地址没有配置可能就需要写死了\n\n辉哥排查日志出现鉴权问题\n\n```bash\nhttp://qq.orig.internal.inke.cn/inke-record-pull/live/%s.flv\n\n\n\n\nhttp://qq.orig.internal.inke.cn/inke-record-pull/live/1641536235301905.flv\nhttp://qq.orig.internal.inke.cn/inke-record-pull/live/1641538516322155.flv\n```\n\n\n\n这是截图日志，已经生成\n\n```bash\n-rw-r--r-- 1 work work 541308 Jan  7 15:05 mp4_2_jpeg_2022-01-07.log\n```\n\n截图日志\n\n```bash\nest)\n[2022-01-07 15:03:19.041] [daily_logger] [error] [?msUid=screenshot]Open http://?msUid=screenshot failed.\n\n[2022-01-07 15:03:21.041] [daily_logger] [info] [?msUid=screenshot]retry 3 times\n[2022-01-07 15:03:21.041] [daily_logger] [info] [?msUid=screenshot]begin mkdir_recursive ...\n[2022-01-07 15:03:21.041] [daily_logger] [info] [?msUid=screenshot]begin open url...\n[2022-01-07 15:03:21.042] [daily_logger] [error] [?msUid=screenshot] Input::open error(-808465656:Server returned 400 Bad Request)\n[2022-01-07 15:03:21.042] [daily_logger] [error] [?msUid=screenshot]Open http://?msUid=screenshot failed.\n\n[2022-01-07 15:03:23.042] [daily_logger] [info] [?msUid=screenshot]####{\"cost_ms\":6005,\"jpeg_count\":0,\"result\":-3,\"retry_times\":3}####\n\n[2022-01-07 15:03:30.153] [daily_logger] [info] [?msUid=screenshot]mainApp param. in_url:?msUid=screenshot, output_dir:/a8root/work/data/media.operimg.screenshotworker/inke/74/1641538516322155-700010274, g_width:256, g_height:4\n```\n\n发现拉流地址有问题 in_url:?msUid=screenshot\n\n\n\n```bash\n2022-01-07 14:59:51.528 realization/task_mgr.go:71 DEBUG recv disp msg:{\"ip\":\"10.128.0.18\",\"appname\":\"inke\",\"live_type\":\"residentlive\",\"broadcast\":\"\",\"event\":\"start\",\"media_type\":\"video\",\"liveid\":\"1641538516322155\",\"uid\":700010274,\"creator_uid\":0,\"slot\":1,\"dis_slot\":0,\"start_time\":1641538543866,\"update_time\":1641538790555,\"stream_type\":\"1\",\"stream_addr\":\"\",\"mix_stream_addr\":\"http://qq.orig.internal.inke.cn/inke-record-pull/live/1641538516322155.flv\",\"asr_stream_addr\":\"\",\"publish_addr\":\"http://temp.zigo.link.inke.cn/publish/trans/inkeaudio/mlinkm/1641538516322155?ikPath=1\\u0026ikFWUrl=rtmp%3A%2F%2Fqqaudio.push.inke.cn%2Flive%2F%7Bliveid%7D%3Fsign%3Dff0e6ec485f0689eMjAwLXFxYXVkaW8ucHVzaC5pbmtlLmNuLTcwMDAxMDI3NA%253D%253D%26ver%3D2\\u0026ikLog=1\\u0026ikSoftAACLev=2\\u0026ikAACBitrate=64000\\u0026uid=700010274\\u0026ikBeauty=1\\u0026ikKnDebug=2\\u0026ikEnableDRC=0\\u0026ikExposure=0\\u0026ikFilter=1\\u0026dd_type=0\\u0026ikDisableFaceSei=1\\u0026ikKnIncr=0\\u0026ikLiveType=residentlive\\u0026ikFaceMorph=1\\u0026ikNewProcess=1\\u0026ikSeven=1\",\"multi_object_id\":\"\",\"mix_object_id\":\"\",\"callback_url\":\"\",\"raw_req\":null,\"audit_shot_cfg\":{\"pic_width\":\"\",\"pic_high\":\"\",\"screenshot_interval\":0}}\n\n\n为空\nstream_addr\":\"\",\"mix_stream_addr\":\"http://qq.orig.internal.inke.cn/inke-record-pull/live/1641538516322155.flv\"\n\nworker 						pullURL:       taskinfo.StreamAddr,  screenshotmanger.go 268\n\n```\n\n\n\n<img src=\"https://raw.githubusercontent.com/xzMhehe/StaticFile_CDN/main/static/mo/20220107151739.png\"/>\n\n```go\n这有问题哈\nrcInfo.MixStreamAddr = fmt.Sprintf(\"http://qq.orig.internal.inke.cn/inke-record-pull/live/%s.flv\", rcInfo.Liveid)\n\n\n应该改为\nrcInfo.StreamAddr = fmt.Sprintf(\"http://qq.orig.internal.inke.cn/inke-record-pull/live/%s.flv\", rcInfo.Liveid)\n```\n\n\n\n部署测试，截图正常\n\n\n\n\n\n\n\n\n\n## 周报\n\n\n\n|             **本周工作**             |                                                              |                                                              |                  |                           |\n| :----------------------------------: | ------------------------------------------------------------ | ------------------------------------------------------------ | ---------------- | ------------------------- |\n|               **项目**               | **进展**                                                     | **问题/风险/效果数据**                                       | **计划完成时间** | **备注**                  |\n|              【缩放图】              | 1 接入老服务腾讯集群34个域名【done】                         |                                                              | 1.6              |                           |\n|               【截图】               | 1 九人团战截图测试【50%】2 eryiyiy截图问题排查【80%】        | 1 九人团战正在测试中2 eryiyi 的测试环境是拉不到流的，线上才行，测试环境没有转码流，需要排期，截图方可与他联调 | 1.7              |                           |\n|               【录播】               | 1 排查陌亲1v1录播失败【done】2 审核接入测试【50%】           | 1 陌亲的web播放器有问题                                      | 1.5              |                           |\n|             【成本结算】             | 1 配合进行联调、数据更新【done】                             |                                                              | 1.6              |                           |\n|             【代理服务】             | 1 与业务方商讨seeklove觅缘周期获取麦位详情接口【done】2 九人团战审核拉流地址使用硬编码【done】 | 1 获取麦位详情我们是传liveid数组给业务方，seeklove业务方打算只处理一条数据，多媒体涉及修改地方较多，不做修改 | 1.4              |                           |\n|           **下周工作计划**           |                                                              |                                                              |                  |                           |\n|               **项目**               | **进展**                                                     | **问题/风险/效果数据**                                       | **计划完成时间** | **备注**                  |\n|               熟悉业务               | 了解流类型等                                                 |                                                              |                  | 多流、合流、连麦流、cdn流 |\n|               【其他】               | 整理自己在公司所学内容并扩展相关知识点学习，记录好每日日报； |                                                              |                  |                           |\n|               **反思**               |                                                              |                                                              |                  |                           |\n| 及时整理新学内容；及时回顾所学内容。 |                                                              |                                                              |                  |                           |\n\n\n\n## 总结\n\n\n\n【缩放图】：\n\n接入老服务34个域名，下周切量部署\n\n【截图】：\n\n九人团战截图测试，这边测试完成，下周就能给他们上正式环境。\n\neryiyiy截图问题排查（eryiyi 的测试环境是拉不到流的，线上才行，需要排期，截图方可与他联调）\n\n【录播】：\n\n录播审核接入测试【50%】\n\n【成本结算】 \n\n配合进行联调、数据更新\n\n【代理服务】：\n\n九人团战（可不说）\n\n\n\n', 1, '2022-04-09 05:42:32', '2022-04-09 05:42:32');
INSERT INTO `gl_info` VALUES ('4', '1', '木兰围场', '123', 'https://coding-init-1254329140.cos.ap-beijing.myqcloud.com/data/mulan2.jpeg', 20, '# 3.7-3.11本周用到的文档\n\n[代理服务接口设计](https://wiki.inkept.cn/pages/viewpage.action?pageId=163119410)\n\n[审核拉流调度接入文档](https://wiki.inkept.cn/pages/viewpage.action?pageId=17963123)\n\n[2021-12-7 主板9人房视频团战需求](https://wiki.inkept.cn/pages/viewpage.action?pageId=214306681)\n\n[业务方接入代理服务具体操作](https://wiki.inkept.cn/pages/viewpage.action?pageId=169958884)\n\n**[新增海外配置](https://wiki.inkept.cn/pages/viewpage.action?pageId=215745522)**\n\n**[5、新app接入标准化2.0行动项](https://wiki.inkept.cn/pages/viewpage.action?pageId=198826698)**\n\n**[2022-1-26 海外muaah 1v1视频接入](https://wiki.inkept.cn/pages/viewpage.action?pageId=225149914)**\n\n**[2022-2-10 统计多媒体服务端使用裸ip的服务](https://wiki.inkept.cn/pages/viewpage.action?pageId=227476316)**\n\n[接入协议](https://wiki.inkept.cn/pages/viewpage.action?pageId=157191222)\n\n[2022-2-17 丝恋电台接入录播](https://wiki.inkept.cn/pages/viewpage.action?pageId=228699590)\n\n[SDK图片缩放接入信息-研发&运维维护](https://wiki.inkept.cn/pages/viewpage.action?pageId=100813521)\n\n\n\n# 3.7-3.11本周用到的服务器\n\n[录播](https://deployment.inkept.cn/release?jobName=cop.inke_owt.media_pdl.stream_servicegroup.record_service.flv2hls_job.flv2hls_cluster.tx-bj3)\n\n[代理服务qa](https://deployment.inkept.cn/k8sRelease?jobName=cop.inke_owt.media_pdl.common_servicegroup.proxy_service.common_job.proxy_cluster.ali-testqa)\n\n[调度qa](https://deployment.inkept.cn/k8sRelease?jobName=cop.inke_owt.media_pdl.disptacher_servicegroup.load_service.disp_job.recoder_cluster.ali-testqa)\n\n\n\n# 本周计划安排\n\n额外会议\n\n对聊额外重视一下\n\n我们的集群有20多个服务\n\n代理自动挂掉截图和录播\n\n全量查询麦位详情需要更改下\n\n\n\n\n\n# 3.7（周一）\n\n## 代理服务\n\n', 1, '2022-04-09 05:44:15', '2022-04-09 05:44:15');
INSERT INTO `gl_info` VALUES ('40d5740e20ef22f4bff48c5e4de4ff57', '1', '测试测试', NULL, 'https://w.wallhaven.cc/full/3z/wallhaven-3z8y59.png', 10, '\n\n\n\n```bash\nbin/sqoop list-databases --connect jdbc:mysql://8.130.17.56:3306/ --username root -password \'(mxz1122.)\'\n```\n\n\n\n\n\n\n\n\n\n# HDFS\n\n1、全部导入\n\n```bash\nbin/sqoop import \\\n> --connect jdbc:mysql://123.56.30.111:3306/cat_travel \\\n> --username root \\\n> --password \'Mc225325\' \\\n> --table user_card_product \\\n> --target-dir /opt/module/mydata \\\n> --delete-target-dir \\\n> --num-mappers 1 \\\n> --fields-terminated-by \"\\t\"\n```\n\n\n\n```bash\n#!/bin/bash\n\n#数据库ip\ntarget_ip=123.56.30.111\n#数据库端口\ntarget_port=3306\n#数据库密码\ntarget_password=Mc225325\n#需要采集的表\ntarget_table=user_card_product\n#数据库\ntarget_data=cat_travel\n#hdfs目录\nhdfs_dir=/opt/module/mydata3\n\necho \'开始导入数据到dfs\'\n\nbin/sqoop import \\\n--connect jdbc:mysql://$target_ip:$target_port/$target_data \\\n--username root \\\n--password $target_password \\\n--table $target_table \\\n--target-dir $hdfs_dir \\\n--delete-target-dir \\\n--num-mappers 1 \\\n--fields-terminated-by \"\\t\"\n\necho \'数据导入完毕\'\n```\n\n\n\n\n\n2、查询导入\n\n```bash\n$ bin/sqoop import \\\n--connect jdbc:mysql://123.56.30.111:3306/company \\\n--username root \\\n--password \'Mc225325\' \\\n--target-dir /opt/module/mydata \\\n--delete-target-dir \\\n--num-mappers 1 \\\n--fields-terminated-by \"\\t\" \\\n--query \'select name,sex from staff where id <=1 and $CONDITIONS;\'\n```\n\n\n\n提示:must contain \'$CONDITIONS\' in WHERE clause.\n 如果 query 后使用的是双引号，则$CONDITIONS 前必须加转移符，防止 shell 识别为自己的 变量。\n\n\n\n', 1, '2022-05-02 13:12:16', '2022-05-02 13:12:16');
INSERT INTO `gl_info` VALUES ('44129b64d729b9597b616f6e679d8520', '1', '承德游记', '123', 'https://w.wallhaven.cc/full/g7/wallhaven-g7kr53.jpg', 1, '# 承德游记\n愉快的一天', 1, '2022-05-02 13:14:00', '2022-05-02 13:14:00');
INSERT INTO `gl_info` VALUES ('5', '3', '承德商厦', '123', 'https://coding-init-1254329140.cos.ap-beijing.myqcloud.com/detail1.jpg', 112, '# 3.7-3.11本周用到的文档\n\n[代理服务接口设计](https://wiki.inkept.cn/pages/viewpage.action?pageId=163119410)\n\n[审核拉流调度接入文档](https://wiki.inkept.cn/pages/viewpage.action?pageId=17963123)\n\n[2021-12-7 主板9人房视频团战需求](https://wiki.inkept.cn/pages/viewpage.action?pageId=214306681)\n\n[业务方接入代理服务具体操作](https://wiki.inkept.cn/pages/viewpage.action?pageId=169958884)\n\n**[新增海外配置](https://wiki.inkept.cn/pages/viewpage.action?pageId=215745522)**\n\n**[5、新app接入标准化2.0行动项](https://wiki.inkept.cn/pages/viewpage.action?pageId=198826698)**\n\n**[2022-1-26 海外muaah 1v1视频接入](https://wiki.inkept.cn/pages/viewpage.action?pageId=225149914)**\n\n**[2022-2-10 统计多媒体服务端使用裸ip的服务](https://wiki.inkept.cn/pages/viewpage.action?pageId=227476316)**\n\n[接入协议](https://wiki.inkept.cn/pages/viewpage.action?pageId=157191222)\n\n[2022-2-17 丝恋电台接入录播](https://wiki.inkept.cn/pages/viewpage.action?pageId=228699590)\n\n[SDK图片缩放接入信息-研发&运维维护](https://wiki.inkept.cn/pages/viewpage.action?pageId=100813521)\n\n\n\n# 3.7-3.11本周用到的服务器\n\n[录播](https://deployment.inkept.cn/release?jobName=cop.inke_owt.media_pdl.stream_servicegroup.record_service.flv2hls_job.flv2hls_cluster.tx-bj3)\n\n[代理服务qa](https://deployment.inkept.cn/k8sRelease?jobName=cop.inke_owt.media_pdl.common_servicegroup.proxy_service.common_job.proxy_cluster.ali-testqa)\n\n[调度qa](https://deployment.inkept.cn/k8sRelease?jobName=cop.inke_owt.media_pdl.disptacher_servicegroup.load_service.disp_job.recoder_cluster.ali-testqa)\n\n\n\n# 本周计划安排\n\n额外会议\n\n对聊额外重视一下\n\n我们的集群有20多个服务\n\n代理自动挂掉截图和录播\n\n全量查询麦位详情需要更改下\n\n\n\n\n\n# 3.7（周一）\n\n## 代理服务\n\n', 1, '2022-04-05 12:39:45', '2022-04-05 12:39:45');
INSERT INTO `gl_info` VALUES ('6', '2', '须弥福寿之庙', '123', 'https://coding-init-1254329140.cos.ap-beijing.myqcloud.com/detail1.jpg', 222, '# 3.7-3.11本周用到的文档\n\n[代理服务接口设计](https://wiki.inkept.cn/pages/viewpage.action?pageId=163119410)\n\n[审核拉流调度接入文档](https://wiki.inkept.cn/pages/viewpage.action?pageId=17963123)\n\n[2021-12-7 主板9人房视频团战需求](https://wiki.inkept.cn/pages/viewpage.action?pageId=214306681)\n\n[业务方接入代理服务具体操作](https://wiki.inkept.cn/pages/viewpage.action?pageId=169958884)\n\n**[新增海外配置](https://wiki.inkept.cn/pages/viewpage.action?pageId=215745522)**\n\n**[5、新app接入标准化2.0行动项](https://wiki.inkept.cn/pages/viewpage.action?pageId=198826698)**\n\n**[2022-1-26 海外muaah 1v1视频接入](https://wiki.inkept.cn/pages/viewpage.action?pageId=225149914)**\n\n**[2022-2-10 统计多媒体服务端使用裸ip的服务](https://wiki.inkept.cn/pages/viewpage.action?pageId=227476316)**\n\n[接入协议](https://wiki.inkept.cn/pages/viewpage.action?pageId=157191222)\n\n[2022-2-17 丝恋电台接入录播](https://wiki.inkept.cn/pages/viewpage.action?pageId=228699590)\n\n[SDK图片缩放接入信息-研发&运维维护](https://wiki.inkept.cn/pages/viewpage.action?pageId=100813521)\n\n\n\n# 3.7-3.11本周用到的服务器\n\n[录播](https://deployment.inkept.cn/release?jobName=cop.inke_owt.media_pdl.stream_servicegroup.record_service.flv2hls_job.flv2hls_cluster.tx-bj3)\n\n[代理服务qa](https://deployment.inkept.cn/k8sRelease?jobName=cop.inke_owt.media_pdl.common_servicegroup.proxy_service.common_job.proxy_cluster.ali-testqa)\n\n[调度qa](https://deployment.inkept.cn/k8sRelease?jobName=cop.inke_owt.media_pdl.disptacher_servicegroup.load_service.disp_job.recoder_cluster.ali-testqa)\n\n\n\n# 本周计划安排\n\n额外会议\n\n对聊额外重视一下\n\n我们的集群有20多个服务\n\n代理自动挂掉截图和录播\n\n全量查询麦位详情需要更改下\n\n\n\n\n\n# 3.7（周一）\n\n## 代理服务\n\n', 1, '2022-04-05 12:39:43', '2022-04-05 12:39:43');
INSERT INTO `gl_info` VALUES ('7', '1', '说走就走的旅行', '123', 'https://coding-init-1254329140.cos.ap-beijing.myqcloud.com/detail1.jpg', 222, '# 3.7-3.11本周用到的文档\n\n[代理服务接口设计](https://wiki.inkept.cn/pages/viewpage.action?pageId=163119410)\n\n[审核拉流调度接入文档](https://wiki.inkept.cn/pages/viewpage.action?pageId=17963123)\n\n[2021-12-7 主板9人房视频团战需求](https://wiki.inkept.cn/pages/viewpage.action?pageId=214306681)\n\n[业务方接入代理服务具体操作](https://wiki.inkept.cn/pages/viewpage.action?pageId=169958884)\n\n**[新增海外配置](https://wiki.inkept.cn/pages/viewpage.action?pageId=215745522)**\n\n**[5、新app接入标准化2.0行动项](https://wiki.inkept.cn/pages/viewpage.action?pageId=198826698)**\n\n**[2022-1-26 海外muaah 1v1视频接入](https://wiki.inkept.cn/pages/viewpage.action?pageId=225149914)**\n\n**[2022-2-10 统计多媒体服务端使用裸ip的服务](https://wiki.inkept.cn/pages/viewpage.action?pageId=227476316)**\n\n[接入协议](https://wiki.inkept.cn/pages/viewpage.action?pageId=157191222)\n\n[2022-2-17 丝恋电台接入录播](https://wiki.inkept.cn/pages/viewpage.action?pageId=228699590)\n\n[SDK图片缩放接入信息-研发&运维维护](https://wiki.inkept.cn/pages/viewpage.action?pageId=100813521)\n\n\n\n# 3.7-3.11本周用到的服务器\n\n[录播](https://deployment.inkept.cn/release?jobName=cop.inke_owt.media_pdl.stream_servicegroup.record_service.flv2hls_job.flv2hls_cluster.tx-bj3)\n\n[代理服务qa](https://deployment.inkept.cn/k8sRelease?jobName=cop.inke_owt.media_pdl.common_servicegroup.proxy_service.common_job.proxy_cluster.ali-testqa)\n\n[调度qa](https://deployment.inkept.cn/k8sRelease?jobName=cop.inke_owt.media_pdl.disptacher_servicegroup.load_service.disp_job.recoder_cluster.ali-testqa)\n\n\n\n# 本周计划安排\n\n额外会议\n\n对聊额外重视一下\n\n我们的集群有20多个服务\n\n代理自动挂掉截图和录播\n\n全量查询麦位详情需要更改下\n\n\n\n\n\n# 3.7（周一）\n\n## 代理服务\n\n', 1, '2022-04-09 15:03:55', '2022-04-09 15:03:55');
INSERT INTO `gl_info` VALUES ('8', '1', '说走就走的旅行2', '123', 'https://coding-init-1254329140.cos.ap-beijing.myqcloud.com/detail1.jpg', 222, '# 3.7-3.11本周用到的文档\n\n[代理服务接口设计](https://wiki.inkept.cn/pages/viewpage.action?pageId=163119410)\n\n[审核拉流调度接入文档](https://wiki.inkept.cn/pages/viewpage.action?pageId=17963123)\n\n[2021-12-7 主板9人房视频团战需求](https://wiki.inkept.cn/pages/viewpage.action?pageId=214306681)\n\n[业务方接入代理服务具体操作](https://wiki.inkept.cn/pages/viewpage.action?pageId=169958884)\n\n**[新增海外配置](https://wiki.inkept.cn/pages/viewpage.action?pageId=215745522)**\n\n**[5、新app接入标准化2.0行动项](https://wiki.inkept.cn/pages/viewpage.action?pageId=198826698)**\n\n**[2022-1-26 海外muaah 1v1视频接入](https://wiki.inkept.cn/pages/viewpage.action?pageId=225149914)**\n\n**[2022-2-10 统计多媒体服务端使用裸ip的服务](https://wiki.inkept.cn/pages/viewpage.action?pageId=227476316)**\n\n[接入协议](https://wiki.inkept.cn/pages/viewpage.action?pageId=157191222)\n\n[2022-2-17 丝恋电台接入录播](https://wiki.inkept.cn/pages/viewpage.action?pageId=228699590)\n\n[SDK图片缩放接入信息-研发&运维维护](https://wiki.inkept.cn/pages/viewpage.action?pageId=100813521)\n\n\n\n# 3.7-3.11本周用到的服务器\n\n[录播](https://deployment.inkept.cn/release?jobName=cop.inke_owt.media_pdl.stream_servicegroup.record_service.flv2hls_job.flv2hls_cluster.tx-bj3)\n\n[代理服务qa](https://deployment.inkept.cn/k8sRelease?jobName=cop.inke_owt.media_pdl.common_servicegroup.proxy_service.common_job.proxy_cluster.ali-testqa)\n\n[调度qa](https://deployment.inkept.cn/k8sRelease?jobName=cop.inke_owt.media_pdl.disptacher_servicegroup.load_service.disp_job.recoder_cluster.ali-testqa)\n\n\n\n# 本周计划安排\n\n额外会议\n\n对聊额外重视一下\n\n我们的集群有20多个服务\n\n代理自动挂掉截图和录播\n\n全量查询麦位详情需要更改下\n\n\n\n\n\n# 3.7（周一）\n\n## 代理服务\n\n', 1, '2022-04-09 15:03:55', '2022-04-09 15:03:55');
INSERT INTO `gl_info` VALUES ('9', '1', '说走就走', '123', 'https://coding-init-1254329140.cos.ap-beijing.myqcloud.com/detail1.jpg', 222, '# 3.7-3.11本周用到的文档\n\n[代理服务接口设计](https://wiki.inkept.cn/pages/viewpage.action?pageId=163119410)\n\n[审核拉流调度接入文档](https://wiki.inkept.cn/pages/viewpage.action?pageId=17963123)\n\n[2021-12-7 主板9人房视频团战需求](https://wiki.inkept.cn/pages/viewpage.action?pageId=214306681)\n\n[业务方接入代理服务具体操作](https://wiki.inkept.cn/pages/viewpage.action?pageId=169958884)\n\n**[新增海外配置](https://wiki.inkept.cn/pages/viewpage.action?pageId=215745522)**\n\n**[5、新app接入标准化2.0行动项](https://wiki.inkept.cn/pages/viewpage.action?pageId=198826698)**\n\n**[2022-1-26 海外muaah 1v1视频接入](https://wiki.inkept.cn/pages/viewpage.action?pageId=225149914)**\n\n**[2022-2-10 统计多媒体服务端使用裸ip的服务](https://wiki.inkept.cn/pages/viewpage.action?pageId=227476316)**\n\n[接入协议](https://wiki.inkept.cn/pages/viewpage.action?pageId=157191222)\n\n[2022-2-17 丝恋电台接入录播](https://wiki.inkept.cn/pages/viewpage.action?pageId=228699590)\n\n[SDK图片缩放接入信息-研发&运维维护](https://wiki.inkept.cn/pages/viewpage.action?pageId=100813521)\n\n\n\n# 3.7-3.11本周用到的服务器\n\n[录播](https://deployment.inkept.cn/release?jobName=cop.inke_owt.media_pdl.stream_servicegroup.record_service.flv2hls_job.flv2hls_cluster.tx-bj3)\n\n[代理服务qa](https://deployment.inkept.cn/k8sRelease?jobName=cop.inke_owt.media_pdl.common_servicegroup.proxy_service.common_job.proxy_cluster.ali-testqa)\n\n[调度qa](https://deployment.inkept.cn/k8sRelease?jobName=cop.inke_owt.media_pdl.disptacher_servicegroup.load_service.disp_job.recoder_cluster.ali-testqa)\n\n\n\n# 本周计划安排\n\n额外会议\n\n对聊额外重视一下\n\n我们的集群有20多个服务\n\n代理自动挂掉截图和录播\n\n全量查询麦位详情需要更改下\n\n\n\n\n\n# 3.7（周一）\n\n## 代理服务\n\n', 1, '2022-04-09 15:03:55', '2022-04-09 15:03:55');
INSERT INTO `gl_info` VALUES ('931c32ca6b5cad6a3f8b7e0398bce9d3', '1', '塞外蟠龙湖', '123', 'https://w.wallhaven.cc/full/6o/wallhaven-6o1g8x.jpg', 1, '# 欢迎来到蟠龙湖\n\n值得一去', 1, '2022-05-02 18:46:41', '2022-05-02 18:46:41');
INSERT INTO `gl_info` VALUES ('ed94fa2e609f1b55c1084767be17706f', '1', '承德一日游', '123', 'https://w.wallhaven.cc/full/wq/wallhaven-wqkgkq.jpg', 1, '# 承德一日游\n\n\n![](https://w.wallhaven.cc/full/wq/wallhaven-wqkgkq.jpg)\n承德周边一日游去哪里比较好？\n承德周边一日游的景点有：\n\n 一、汤泉行宫，二、滴水崖，三、朝阳洞等\n承德是河北省下辖地级市，地处中国华北地区、河北省东北部，总面积39519平方公里，被誉为“中国摄影之乡”。\n\n# 一、汤泉行宫\n位于昌平区小汤山镇，为明清帝后龙浴之处。从明朝起辟为皇帝禁苑。清康熙54年1715年在此建汤泉行宫，建汉 汤泉行宫白玉方池，供皇帝、显贵洗浴。乾隆年间，称原行宫为前宫，向北扩展建成一座清幽的园林，为后宫。\n\n![](https://images.weelv.com/question/2b2bbe2e7694b3a4fb68aeb921ed27ca.png?x-oss-process=img/resize,w_750)\n\n# 二、滴水崖\n滴水崖是山西灵石石膏山风景名胜区的一处景观，位于的天河岸边香炉峰下，它源自滴水沟，呈南北走向，崖高达60余米，长二公里有余，常年有水流淌，如珠挂线，一条条、一缕缕、似断似续，就像一幅用珍珠缀成的水帘，形成“滴水垂帘”的瀑布奇观。真可谓“飞流如练林峦出，滴水垂帘天上来。”\n\n# 三、朝阳洞\n朝阳洞是“承德十大景”之一，距承德市区20公里，位于河北承德市承德县仓子乡境内。据清代志书《承德府志》记载，朝阳洞“在府治东稍南三十七里。石窦嵌空，横贯山腹”，“晓日初升光射罅漏，隔山可见朝阳。”朝阳洞由此而得名。\n\n# 承德\n市气温由西向东逐渐增高，全年平均气温9.0℃。平均气温年变化特征是：从二月份起温度逐月增高，夏季最热月平均气温23.0℃，无炎热期，形成良好的避暑环境。八月份温度开始下降，冬季最冷月平均气温-10℃。', 1, '2022-05-04 09:33:18', '2022-05-04 09:33:18');
INSERT INTO `gl_info` VALUES ('f8713fac545d80e985c5287916a2a78c', '1', '测试测试测试测试', NULL, 'https://w.wallhaven.cc/full/8o/wallhaven-8owwjy.jpg', 100, '测试测试测试测试测试', 0, '2022-05-02 13:12:18', '2022-05-02 13:12:18');
COMMIT;

-- ----------------------------
-- Table structure for product_activity
-- ----------------------------
DROP TABLE IF EXISTS `product_activity`;
CREATE TABLE `product_activity` (
  `pid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `activity_name` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `des` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `sort` tinyint(4) DEFAULT '0',
  `activity_status` tinyint(4) DEFAULT '0',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`pid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of product_activity
-- ----------------------------
BEGIN;
INSERT INTO `product_activity` VALUES ('0', '最新', '最新发布', 0, 0, '2022-04-05 11:52:44', '2022-04-05 11:52:44');
INSERT INTO `product_activity` VALUES ('1', '优选', '飞猫优选', 1, 0, '2022-04-05 11:52:59', '2022-04-05 11:52:59');
INSERT INTO `product_activity` VALUES ('2', '热门', '热门', 2, 0, '2022-04-05 11:53:03', '2022-04-05 11:53:03');
COMMIT;

-- ----------------------------
-- Table structure for product_analyse
-- ----------------------------
DROP TABLE IF EXISTS `product_analyse`;
CREATE TABLE `product_analyse` (
  `pid` varchar(32) COLLATE utf8mb4_general_ci NOT NULL,
  `product_pid` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `num` int(11) DEFAULT NULL,
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`pid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of product_analyse
-- ----------------------------
BEGIN;
INSERT INTO `product_analyse` VALUES ('0f54ff1f024ef7a901f1d6a2fed994e7', 'c165d72339d57389f57dd28f4acfc314', 2, '2022-05-02 22:36:11', '2022-05-02 22:36:11');
INSERT INTO `product_analyse` VALUES ('14235840e22cc8ae147e4781ef779bcf', '4abd7ec701a27d322ddf404d4fa37892', 1, '2022-05-02 22:36:11', '2022-05-02 22:36:11');
INSERT INTO `product_analyse` VALUES ('1ab25654ac001c91121ab028a5a92c88', '222', 16, '2022-05-02 22:36:11', '2022-05-02 22:36:11');
INSERT INTO `product_analyse` VALUES ('61f664c5d0ce4494b99bbd3cb0bc07e7', 'c6d097a5da1d7c103817713334e7ad84', 1, '2022-05-02 22:36:11', '2022-05-02 22:36:11');
INSERT INTO `product_analyse` VALUES ('8562f26d704b04e22b73cdfbe16e82a3', 'f54825904a5a89603550a83ead17cf14', 5, '2022-05-02 22:36:11', '2022-05-02 22:36:11');
INSERT INTO `product_analyse` VALUES ('990dda332d0fd18eabc063b6a42a7126', '83bc3c6a2790efd69f74ff95acab9687', 2, '2022-05-02 22:36:11', '2022-05-02 22:36:11');
INSERT INTO `product_analyse` VALUES ('9f97f310c41e3f13e5b0f71246ba929e', '8c8867de2c376f594dc206d30e592c71', 3, '2022-05-02 22:36:11', '2022-05-02 22:36:11');
INSERT INTO `product_analyse` VALUES ('ac96c407d7906298b54b653d71c6391d', '233', 6, '2022-05-02 22:36:11', '2022-05-02 22:36:11');
INSERT INTO `product_analyse` VALUES ('af568c7bc243469a0ac991e9a41dccfa', 'b843b1e84d307397821e5063176af551', 3, '2022-05-02 22:36:11', '2022-05-02 22:36:11');
COMMIT;

-- ----------------------------
-- Table structure for product_carousel
-- ----------------------------
DROP TABLE IF EXISTS `product_carousel`;
CREATE TABLE `product_carousel` (
  `pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `product_pid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `img_path` varchar(264) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `des` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `carousel_status` tinyint(4) DEFAULT NULL COMMENT '备注',
  `sort` tinyint(4) NOT NULL,
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`pid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Cat轮播图';

-- ----------------------------
-- Records of product_carousel
-- ----------------------------
BEGIN;
INSERT INTO `product_carousel` VALUES ('1', '1', '塞外蟠龙湖', 'https://coding-init-1254329140.cos.ap-beijing.myqcloud.com/home-banner-carry.png', '塞外蟠龙湖，度假必去', 1, 0, '2022-03-22 13:09:42', '2022-03-22 13:09:42');
INSERT INTO `product_carousel` VALUES ('1cd07d75a2e17b4934d95bd8c6efe647', '222', '双塔山神秘古塔 ', 'https://p3.itc.cn/images01/20210710/dab0eecb4eca4e7394e1b9f19e102412.jpeg', '世界未解之谜：河北双塔山神秘古塔，千年前的古人是如何建成的？ ', 1, 3, '2022-03-22 13:09:59', '2022-03-22 13:09:59');
INSERT INTO `product_carousel` VALUES ('2', '08591edf0e7c6ed434aaca02ff2a2127', '皇家避暑胜地', 'https://coding-init-1254329140.cos.ap-beijing.myqcloud.com/bishu2.jpeg', '夏日避暑', 1, 0, '2022-03-22 13:10:33', '2022-03-22 13:10:33');
COMMIT;

-- ----------------------------
-- Table structure for product_category
-- ----------------------------
DROP TABLE IF EXISTS `product_category`;
CREATE TABLE `product_category` (
  `pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `category_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `parent_pid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `product_count` tinyint(4) NOT NULL DEFAULT '0' COMMENT '该分类下的商品数量',
  `img_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sort` tinyint(4) DEFAULT NULL,
  `cat_level` tinyint(4) DEFAULT NULL,
  `category_status` tinyint(4) NOT NULL COMMENT '分类状态，2专题\n',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`pid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='分类';

-- ----------------------------
-- Records of product_category
-- ----------------------------
BEGIN;
INSERT INTO `product_category` VALUES ('1', '最新', '0', 1, NULL, 1, 1, 1, '2022-03-07 22:01:18', '2022-03-07 22:01:18');
INSERT INTO `product_category` VALUES ('10', '优选', '0', 1, NULL, 3, 1, 1, '2022-03-10 13:29:45', '2022-03-10 13:29:45');
INSERT INTO `product_category` VALUES ('11', '当季推荐', '0', 1, 'https://coding-init-1254329140.cos.ap-beijing.myqcloud.com/special-manage-6.jpg', 9, 1, 2, '2022-04-01 14:04:16', '2022-04-01 14:04:16');
INSERT INTO `product_category` VALUES ('12', '平泉市', '0', 0, 'https://coding-init-1254329140.cos.ap-beijing.myqcloud.com/one.jpg', 9, 1, 2, '2022-03-19 13:08:57', '2022-03-19 13:08:57');
INSERT INTO `product_category` VALUES ('2', '推荐', '0', 1, NULL, 2, 1, 1, '2022-03-07 22:01:21', '2022-03-07 22:01:21');
INSERT INTO `product_category` VALUES ('3', '最热', '0', 1, NULL, 3, 1, 1, '2022-03-10 13:29:42', '2022-03-10 13:29:42');
INSERT INTO `product_category` VALUES ('4', '承德县', '0', 2, 'https://coding-init-1254329140.cos.ap-beijing.myqcloud.com/special-prototype-4.jpg', 4, 1, 2, '2022-04-01 14:07:35', '2022-04-01 14:07:35');
INSERT INTO `product_category` VALUES ('5', '兴隆县', '0', 0, 'https://coding-init-1254329140.cos.ap-beijing.myqcloud.com/special-novice-1.jpg', 5, 1, 2, '2022-04-01 14:07:40', '2022-04-01 14:07:40');
INSERT INTO `product_category` VALUES ('6', '宽城县', '0', 0, 'https://coding-init-1254329140.cos.ap-beijing.myqcloud.com/adobe-cc-2019-special-2.jpg', 6, 1, 2, '2022-04-01 14:07:43', '2022-04-01 14:07:43');
INSERT INTO `product_category` VALUES ('7', '滦平县', '0', 1, 'https://coding-init-1254329140.cos.ap-beijing.myqcloud.com/special-photo-edit.jpg', 7, 1, 2, '2022-04-01 14:07:50', '2022-04-01 14:07:50');
INSERT INTO `product_category` VALUES ('8', '丰宁满族自治县', '0', 2, 'https://coding-init-1254329140.cos.ap-beijing.myqcloud.com/special-pm2-1.jpg', 8, 1, 2, '2022-04-01 14:07:53', '2022-04-01 14:07:53');
INSERT INTO `product_category` VALUES ('9', '围场满族自治县', '0', 2, 'https://coding-init-1254329140.cos.ap-beijing.myqcloud.com/special-mindmap-5.jpg', 9, 1, 2, '2022-04-01 14:07:57', '2022-04-01 14:07:57');
COMMIT;

-- ----------------------------
-- Table structure for product_image
-- ----------------------------
DROP TABLE IF EXISTS `product_image`;
CREATE TABLE `product_image` (
  `pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `product_pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '商品外键',
  `img_url` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '图片链接',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`pid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='景点图片';

-- ----------------------------
-- Records of product_image
-- ----------------------------
BEGIN;
INSERT INTO `product_image` VALUES ('1ab3d8a990a28b05', '9ea85a07136bcab40e7d09aa5f8849e8', 'https://youimg1.tripcdn.com/target/0106h1200065s7n53B3A9_C_760_506.jpg?proc=source%2ftrip', '2022-04-09 06:03:49', '2022-04-09 06:03:49');
INSERT INTO `product_image` VALUES ('1ab3d8a990a28b05eff473', '9ea85a07136bcab40e7d09aa5f8849e8', 'https://youimg1.tripcdn.com/target/0105c120007578pj690A4_C_760_506.jpg?proc=source%2ftrip', '2022-04-09 06:03:19', '2022-04-09 06:03:19');
INSERT INTO `product_image` VALUES ('1ab3d8a990a28b05eff473a58403cd60', '9ea85a07136bcab40e7d09aa5f8849e8', 'https://youimg1.tripcdn.com/target/100i180000014zi1x9051_C_760_506.jpg?proc=source%2ftrip', '2022-04-09 06:03:05', '2022-04-09 06:03:05');
INSERT INTO `product_image` VALUES ('2', '08591edf0e7c6ed434aaca02ff2a2127', 'https://youimg1.tripcdn.com/target/010401200065th5epC180_C_760_506.jpg?proc=source%2ftrip', '2022-03-22 12:59:14', '2022-03-22 12:59:14');
INSERT INTO `product_image` VALUES ('2bed032a402e3f081cd415c6', '08591edf0e7c6ed434aaca02ff2a2127', 'https://youimg1.tripcdn.com/target/0103q1200065teqg5FD3D_C_760_506.jpg?proc=source%2ftrip', '2022-03-22 13:00:36', '2022-03-22 13:00:36');
INSERT INTO `product_image` VALUES ('31231231312', '222', 'https://youimg1.tripcdn.com/target/100w12000000s36il9710_C_760_506.jpg?proc=source%2ftrip', '2022-03-22 13:05:43', '2022-03-22 13:05:43');
INSERT INTO `product_image` VALUES ('31231231312222', '222', 'https://p3.itc.cn/images01/20210710/dab0eecb4eca4e7394e1b9f19e102412.jpeg', '2022-03-22 12:56:50', '2022-03-22 12:56:50');
INSERT INTO `product_image` VALUES ('38aac02b11cd3e1', 'f54825904a5a89603550a83ead17cf14', 'https://youimg1.tripcdn.com/target/100g0z000000nks38C6FF_C_760_506.jpg?proc=source%2ftrip', '2022-04-09 06:09:09', '2022-04-09 06:09:09');
INSERT INTO `product_image` VALUES ('38aac02b11cd3e108', 'f54825904a5a89603550a83ead17cf14', 'https://youimg1.tripcdn.com/target/0104x120004fhacaf5353_C_760_506.jpg?proc=source%2ftrip', '2022-04-09 06:09:09', '2022-04-09 06:09:09');
INSERT INTO `product_image` VALUES ('38aac02b11cd3e10835a5dcc1a0734af', 'f54825904a5a89603550a83ead17cf14', 'https://youimg1.tripcdn.com/target/010541200066hbte6AD25_C_760_506.jpg?proc=source%2ftrip', '2022-04-09 06:09:09', '2022-04-09 06:09:09');
INSERT INTO `product_image` VALUES ('5bbcdfb7824ef81cf64879db1a12f80f', 'bf93177ff0a289986dfd71fcc070f9ac', 'https://coding-init-1254329140.cos.ap-beijing.myqcloud.com/detail1.jpg', '2022-03-14 19:43:38', '2022-03-14 19:43:38');
INSERT INTO `product_image` VALUES ('600f9ce39f72cd02ed3d11479bfb4c46', 'e610f3f095853d90412509b7eae46763', 'https://coding-init-1254329140.cos.ap-beijing.myqcloud.com/detail1.jpg', '2022-03-14 19:43:39', '2022-03-14 19:43:39');
INSERT INTO `product_image` VALUES ('6bed032a402e3f081cd415c6', '08591edf0e7c6ed434aaca02ff2a2127', 'https://youimg1.tripcdn.com/target/0105c120007578pj690A4_C_760_506.jpg?proc=source%2ftrip', '2022-03-22 13:00:21', '2022-03-22 13:00:21');
INSERT INTO `product_image` VALUES ('6bed032a402e3f08d02806991cd415c6', '08591edf0e7c6ed434aaca02ff2a2127', 'https://youimg1.tripcdn.com/target/0103q1200065teqg5FD3D_C_900_600.jpg_.webp?proc=source%2ftrip', '2022-03-22 12:58:59', '2022-03-22 12:58:59');
INSERT INTO `product_image` VALUES ('72edae6db4381fd317c96098861d1003', 'b843b1e84d307397821e5063176af551', 'https://youimg1.tripcdn.com/target/0106h1200065s7n53B3A9_C_760_506.jpg?proc=source%2ftrip', '2022-04-09 06:04:47', '2022-04-09 06:04:47');
INSERT INTO `product_image` VALUES ('83d080d90551029a6e262f58ec6646ca', 'c165d72339d57389f57dd28f4acfc314', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fbkimg.cdn.bcebos.com%2Fpic%2F0df3d7ca7bcb0a46c06cb6da6263f6246a60af82&refer=http%3A%2F%2Fbkimg.cdn.bcebos.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=auto?sec=1652076479&t=05ed3a42c846a0e8875362d229037145', '2022-04-09 06:08:05', '2022-04-09 06:08:05');
INSERT INTO `product_image` VALUES ('994ec1bf0d415c5be15745a1dbc41a00', '83bc3c6a2790efd69f74ff95acab9687', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fss2.meipian.me%2Fuser%2F22488386%2Fc82783af63900001db8e104b1ba010a8.jpg-mobile&refer=http%3A%2F%2Fss2.meipian.me&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=auto?sec=1652076387&t=81216ee44129b139b1c3b77cb7d6bc49', '2022-04-09 06:06:35', '2022-04-09 06:06:35');
INSERT INTO `product_image` VALUES ('b7231f356f65b4d2465f0a97a810d956', '8c8867de2c376f594dc206d30e592c71', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fimage.photos.nphoto.net%2F201803%2F19%2Ff5e1feca10eab8841b06cfdc5f864ea5.jpg&refer=http%3A%2F%2Fimage.photos.nphoto.net&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=auto?sec=1652076910&t=5c90628cef5725611485be2c40194d8e', '2022-04-09 06:15:26', '2022-04-09 06:15:26');
INSERT INTO `product_image` VALUES ('c9b21c10e19219fd9e1dd19f', '4abd7ec701a27d322ddf404d4fa37892', 'https://youimg1.tripcdn.com/target/100f0s000000hl1vc8C6E_C_760_506.jpg?proc=source%2ftrip', '2022-04-09 06:17:28', '2022-04-09 06:17:28');
INSERT INTO `product_image` VALUES ('c9b21c10e19219fd9e1dd19fd71f2be8', '4abd7ec701a27d322ddf404d4fa37892', 'https://youimg1.tripcdn.com/target/100m0s000000husfcBCA7_C_760_506.jpg?proc=source%2ftrip', '2022-04-09 06:17:28', '2022-04-09 06:17:28');
INSERT INTO `product_image` VALUES ('cd8332b0b5f101d530f2d3014009b6ec', 'bf93177ff0a289986dfd71fcc070f9ac', 'https://coding-init-1254329140.cos.ap-beijing.myqcloud.com/detail1.jpg', '2022-03-14 19:43:44', '2022-03-14 19:43:44');
INSERT INTO `product_image` VALUES ('dd22653373e5f0e145430d9c6eadb79e', '5ff69a64785a70f0571b4cf267ff6a55', 'https://coding-init-1254329140.cos.ap-beijing.myqcloud.com/detail1.jpg', '2022-03-14 19:43:45', '2022-03-14 19:43:45');
INSERT INTO `product_image` VALUES ('e25050903d992', '1', 'https://youimg1.tripcdn.com/target/01049120008ran0330BC9_C_760_506.jpg?proc=source%2ftrip', '2022-03-22 13:03:48', '2022-03-22 13:03:48');
INSERT INTO `product_image` VALUES ('e2505090e239', '233', 'https://coding-init-1254329140.cos.ap-beijing.myqcloud.com/data/mulan2.jpeg', '2022-04-09 05:35:32', '2022-04-09 05:35:32');
INSERT INTO `product_image` VALUES ('e2505090e239343d992', '1', 'https://youimg1.tripcdn.com/target/0106o120008raxqh91BA9_C_760_506.jpg?proc=source%2ftrip', '2022-03-22 13:03:36', '2022-03-22 13:03:36');
INSERT INTO `product_image` VALUES ('e2505090e239343d992cd', '1', 'https://youimg1.tripcdn.com/target/0103v120008raxnyu50F3_C_760_506.jpg?proc=source%2ftrip', '2022-03-22 13:03:19', '2022-03-22 13:03:19');
INSERT INTO `product_image` VALUES ('e2505090e2396343d992cf93d', '233', 'https://coding-init-1254329140.cos.ap-beijing.myqcloud.com/data/mulan1.jpeg', '2022-04-09 05:34:50', '2022-04-09 05:34:50');
INSERT INTO `product_image` VALUES ('e2505090e239c', 'c6d097a5da1d7c103817713334e7ad84', 'https://youimg1.tripcdn.com/target/0105a120008a4n7d7B2E8_C_760_506.jpg?proc=source%2ftrip', '2022-04-09 06:00:49', '2022-04-09 06:00:49');
INSERT INTO `product_image` VALUES ('e2505090e239c88afc36343d992cd', '1', 'https://coding-init-1254329140.cos.ap-beijing.myqcloud.com/detail1.jpg', '2022-03-14 19:43:46', '2022-03-14 19:43:46');
INSERT INTO `product_image` VALUES ('e2505090e239c88afc36343d992cf93d', 'c6d097a5da1d7c103817713334e7ad84', 'https://youimg1.tripcdn.com/target/0105r1200086skeva091D_C_760_506.jpg?proc=source%2ftrip', '2022-04-09 06:00:33', '2022-04-09 06:00:33');
COMMIT;

-- ----------------------------
-- Table structure for product_info
-- ----------------------------
DROP TABLE IF EXISTS `product_info`;
CREATE TABLE `product_info` (
  `pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `category_pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '景点分类，外键',
  `product_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '景点名称',
  `price` decimal(10,2) DEFAULT '0.00' COMMENT '出售价格',
  `real_price` decimal(10,2) DEFAULT '0.00' COMMENT '真实价格',
  `postage` decimal(10,2) DEFAULT '0.00' COMMENT '邮费',
  `views` bigint(20) DEFAULT NULL COMMENT '浏览量',
  `des` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '详细信息',
  `product_status` tinyint(4) DEFAULT '1' COMMENT '状态 上架1 下架0',
  `activity_status` tinyint(4) DEFAULT '0' COMMENT '活动状态',
  `product_type` tinyint(4) DEFAULT '1' COMMENT '景点状态',
  `polish_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '擦亮时间，按该时间进行查询，精确到时分秒',
  `end_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '下架时间',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`pid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='景点表';

-- ----------------------------
-- Records of product_info
-- ----------------------------
BEGIN;
INSERT INTO `product_info` VALUES ('08591edf0e7c6ed434aaca02ff2a2127', '11', '避暑山庄', 21.00, 100.00, 0.00, 71, '避暑山庄，又称“热河行宫”“承德离宫”。它从康熙四十二年（1703年）开始动工兴建，至乾隆五十七年（1792年）最后落成，历时89年。', 1, 0, 1, '2022-03-22 12:30:01', '2022-03-22 12:30:01', '2022-03-22 12:30:01', '2022-03-22 12:30:01');
INSERT INTO `product_info` VALUES ('1', '2', '塞外蟠龙湖', 36.00, 99.00, 0.00, 2029, '塞外蟠龙湖塞外蟠龙湖塞外蟠龙湖塞外蟠龙湖塞外蟠龙湖塞外蟠龙湖塞外蟠龙湖塞外蟠龙湖塞外蟠龙湖塞外蟠龙湖塞外蟠龙湖塞外蟠龙湖塞外蟠龙湖塞外蟠龙湖塞外蟠龙湖塞外蟠龙湖塞外蟠龙湖塞外蟠龙湖塞外蟠龙湖塞外蟠龙湖塞外蟠龙湖塞外蟠龙湖', 1, 0, 1, '2022-04-07 16:28:19', '2022-04-07 16:28:19', '2022-04-07 16:28:19', '2022-04-07 16:28:19');
INSERT INTO `product_info` VALUES ('222', '2', '双塔山', 31.00, 99.00, 0.00, 46, '承德避暑山庄，又名“承德离宫”或“热河行宫”，是世界文化遗产、国家AAAAA级旅游景区、全国重点文物保护单位、中国四大名园之一。山庄位于河北省承德市中心北部，武烈河西岸一带狭长的谷地上，是清代皇帝夏天避暑和处理政务的场所。避暑山庄分宫殿区、湖泊区、平原区、山峦区四大部分。山庄始建于1703年，1961年被公布为第一批全国重点文物保护单位；1994年列入《世界遗产名录》。', 1, 0, 1, '2022-04-07 16:28:24', '2022-04-07 16:28:24', '2022-04-07 16:28:24', '2022-04-07 16:28:24');
INSERT INTO `product_info` VALUES ('233', '4', '木兰围场', 21.00, 99.00, 0.00, 45, '围场位于河北省北面，和内蒙古自治区交界。围场县以曾是清代著名的皇家狩猎名苑—木兰围场所在地而得名，境内旅游资源丰富。电视剧《还珠格格》即拍摄于木兰围场。现在，围场还保留著东庙宫、乾隆打虎洞和石刻、古长城说碑等十几处清代皇帝行围狩猎和北巡围场的文物古蹟，以及点将台、将军泡子、十二座连营等古战场遗址。', 1, 0, 1, '2022-04-09 05:36:30', '2022-04-09 05:36:30', '2022-04-09 05:36:30', '2022-04-09 05:36:30');
INSERT INTO `product_info` VALUES ('4abd7ec701a27d322ddf404d4fa37892', '9', '坝上草原', 11.00, 99.00, 0.00, 46, '坝上草原，是个避暑胜地。嘉年华里，可以看表演，也可以吃饭。总之累了一天，到这里可以休息一下。演员的表演，挺卖力，篝火晚会和烤全羊，孩子也喜欢。', 1, 0, 1, '2022-04-09 06:20:12', '2022-04-09 06:20:12', '2022-04-09 06:20:12', '2022-04-09 06:20:12');
INSERT INTO `product_info` VALUES ('5ff69a64785a70f0571b4cf267ff6a55', '2', '景点2', 15.00, 99.00, 0.00, 26, '承德避暑山庄，又名“承德离宫”或“热河行宫”，是世界文化遗产、国家AAAAA级旅游景区、全国重点文物保护单位、中国四大名园之一。山庄位于河北省承德市中心北部，武烈河西岸一带狭长的谷地上，是清代皇帝夏天避暑和处理政务的场所。避暑山庄分宫殿区、湖泊区、平原区、山峦区四大部分。山庄始建于1703年，1961年被公布为第一批全国重点文物保护单位；1994年列入《世界遗产名录》。', 1, 0, 1, '2022-03-21 09:51:07', '2022-03-21 09:51:07', '2022-03-21 09:51:07', '2022-03-21 09:51:07');
INSERT INTO `product_info` VALUES ('83bc3c6a2790efd69f74ff95acab9687', '7', '兴隆县大水泉乡', 11.00, 99.00, 0.00, 32, '这里曾是满清的皇家禁地，真正的后龙风水，被尘封了254年（1661-1915）的神秘山脉。兴隆山景区38平方公里，核心区域14.7平方公里，不仅有奇峰和怪石，还有云海中的美妙仙境。兴隆山景区地形地貌奇特，山水资源丰富，以“峰奇、石异、水秀、谷幽”著称，峡谷溪流纵横交错，形成一道天然的山水画廊，漫步山间，秀美山水和静谧村落和谐相融。景区奇峰异石多姿，怪石林立，鬼斧神工，地质结构复杂，四周山峦起伏，沟壑纵横，经千万年切割冲刷形成的恒河峡谷贯穿南北，素有“小张家界”之称。', 1, 0, 1, '2022-03-22 12:31:44', '2022-03-22 12:31:44', '2022-03-22 12:31:44', '2022-03-22 12:31:44');
INSERT INTO `product_info` VALUES ('8c8867de2c376f594dc206d30e592c71', '8', '水下长城', 12.00, 99.00, 0.00, 33, '水下长城位于河北省承德市宽城满族自治县境内的潘家口水库。整个景区水域纵深60公里，潘家口、喜峰口等长城关口没于水下，恰似镶嵌在燕山深处的一颗璀璨明珠。\n景区内山清水秀，峰回水转，湖光山色相得益彰，有“塞外小桂林”和“蟠龙湖”的别名。', 1, 0, 1, '2022-04-09 06:16:10', '2022-04-09 06:16:10', '2022-04-09 06:16:10', '2022-04-09 06:16:10');
INSERT INTO `product_info` VALUES ('9ea85a07136bcab40e7d09aa5f8849e8', '1', '普陀宗乘之庙', 23.00, 99.00, 0.00, 30, '普陀宗乘之庙始建于乾隆三十二年（1767年），四年后建成，是“外八庙”中规模最大的一座庙宇，因仿拉萨布达拉宫而建，俗称小布达拉宫。', 1, 1, 1, '2022-04-04 23:25:54', '2022-04-04 23:25:54', '2022-04-04 23:25:54', '2022-04-04 23:25:54');
INSERT INTO `product_info` VALUES ('b843b1e84d307397821e5063176af551', '4', '小布达拉宫', 25.00, 99.00, 0.00, 30, '普陀宗乘之庙始建于乾隆三十二年（1767年），四年后建成，是“外八庙”中规模最大的一座庙宇，因仿拉萨布达拉宫而建，俗称小布达拉宫。', 1, 2, 1, '2022-04-09 06:04:29', '2022-04-09 06:04:29', '2022-04-09 06:04:29', '2022-04-09 06:04:29');
INSERT INTO `product_info` VALUES ('c165d72339d57389f57dd28f4acfc314', '8', '董存瑞烈士陵园', 0.00, 0.00, 0.00, 33, '董存瑞烈士陵园位于河北省隆化县城西北的苔山脚下伊逊河东岸，是为纪念全国著名战斗英雄董存瑞烈士于1954年在清康熙皇帝波洛河屯行宫旧址上修建的。', 1, 0, 1, '2022-03-22 12:30:27', '2022-03-22 12:30:27', '2022-03-22 12:30:27', '2022-03-22 12:30:27');
INSERT INTO `product_info` VALUES ('c6d097a5da1d7c103817713334e7ad84', '9', '塞罕坝国家森林公园', 21.00, 99.00, 0.00, 31, '【景色】景色宜人，空气新鲜，一年四季的景色，各有各的美，大草原令人心旷神怡，心情都是好的，我们走的是林区，沿途的景色非常好【趣味】七八月左右去的时候鲜花还开著，草也是最绿的，十月去的时候虽然已经打草了但是遍布著秋天的落恭弘=叶 恭弘，也是非常好看的，冬天同样也适合玩越野的小伙伴呀【性价比】这里比较适合自驾游，喜欢哪里就停在哪里，沿途的景色都可以观赏到，我们是住在御道口附近的酒店，那附近也会有篝火晚会，体验草原的风光草原真的是散心的最好去处了，看到一望无际的大草原整个人的心情都会很好，但是这里早晚会比较冷一些，记得带些厚衣服哦', 1, 0, 1, '2022-04-09 06:02:12', '2022-04-09 06:02:12', '2022-04-09 06:02:12', '2022-04-09 06:02:12');
INSERT INTO `product_info` VALUES ('f54825904a5a89603550a83ead17cf14', '4', '金山岭长城', 21.00, 99.00, 0.00, 43, '金山岭长城盘桓在河北省滦平县巴克什营花楼沟一带的大小金山岭上。大小金山岭位于燕山第一峰雾灵山与古北口卧虎岭之间，这里的山势十分险峻，峰峦叠嶂、丛林若海、景色苍茫。', 1, 0, 1, '2022-03-22 12:29:51', '2022-03-22 12:29:51', '2022-03-22 12:29:51', '2022-03-22 12:29:51');
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `parent_pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '父菜单ID，一级菜单为0',
  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '菜单URL',
  `perms` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：user:list,user:create)',
  `component` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `type` tinyint(4) NOT NULL COMMENT '类型     0：目录   1：菜单   2：按钮',
  `icon` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '菜单图标',
  `order_num` tinyint(4) DEFAULT NULL COMMENT '排序',
  `status` tinyint(4) NOT NULL,
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`pid`) USING BTREE,
  UNIQUE KEY `name` (`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES ('1', '0', '系统管理', '', 'sys:manage', '', 0, 'el-icon-s-operation', 1, 1, '2021-01-15 18:58:18', '2021-01-15 18:58:20');
INSERT INTO `sys_menu` VALUES ('10', '2', '修改用户', NULL, 'sys:user:update', NULL, 2, NULL, 2, 1, '2021-01-17 21:49:03', '2021-01-17 21:53:04');
INSERT INTO `sys_menu` VALUES ('1000', '7a53a52c9bbfb6d98073c5363ae699c1', '用户管理', '/people/people', 'people:user:list', 'people/People', 1, 'el-icon-s-custom', 1, 1, '2021-08-14 08:07:57', '2021-08-14 08:07:57');
INSERT INTO `sys_menu` VALUES ('1001', '7a53a52c9bbfb6d98073c5363ae699c1', '实名认证', '/people/school', 'people:school:list', 'people/School', 1, 'el-icon-s-claim', 2, 1, '2021-08-14 08:06:54', '2021-08-14 08:06:54');
INSERT INTO `sys_menu` VALUES ('100212112', '7a53a52c9bbfb6d98073c5363ae699ca', '攻略管理', '/gl/gl', 'gl:gl:list', 'gl/Gl', 1, 'el-icon-star-on', 1, 1, '2022-03-15 13:32:21', '2022-03-15 13:32:21');
INSERT INTO `sys_menu` VALUES ('1003', '7a53a52c9bbfb6d98073c5363ae699c2', '景点管理', '/product/product', 'product:product:list', 'product/Product', 1, 'el-icon-camera-solid', 1, 1, '2022-03-15 13:14:06', '2022-03-15 13:14:06');
INSERT INTO `sys_menu` VALUES ('10038989899999898', '7a53a52c9bbfb', '专题管理', '/special/special', 'special: special:list', 'special/Special', 1, 'el-icon-s-finance', 1, 1, '2022-04-09 15:48:21', '2022-04-09 15:48:21');
INSERT INTO `sys_menu` VALUES ('11', '2', '删除用户', NULL, 'sys:user:delete', NULL, 2, NULL, 3, 1, '2021-01-17 21:49:21', NULL);
INSERT INTO `sys_menu` VALUES ('12', '2', '分配角色', NULL, 'sys:user:role', NULL, 2, NULL, 4, 1, '2021-01-17 21:49:58', NULL);
INSERT INTO `sys_menu` VALUES ('13', '2', '重置密码', NULL, 'sys:user:repass', NULL, 2, NULL, 5, 1, '2021-01-17 21:50:36', NULL);
INSERT INTO `sys_menu` VALUES ('14', '3', '修改角色', NULL, 'sys:role:update', NULL, 2, NULL, 2, 1, '2021-01-17 21:51:14', NULL);
INSERT INTO `sys_menu` VALUES ('15', '3', '删除角色', NULL, 'sys:role:delete', NULL, 2, NULL, 3, 1, '2021-01-17 21:51:39', NULL);
INSERT INTO `sys_menu` VALUES ('16', '3', '分配权限', NULL, 'sys:role:perm', NULL, 2, NULL, 5, 1, '2021-01-17 21:52:02', NULL);
INSERT INTO `sys_menu` VALUES ('17', '4', '添加菜单', NULL, 'sys:menu:save', NULL, 2, NULL, 1, 1, '2021-01-17 21:53:53', '2021-01-17 21:55:28');
INSERT INTO `sys_menu` VALUES ('18', '4', '修改菜单', NULL, 'sys:menu:update', NULL, 2, NULL, 2, 1, '2021-01-17 21:56:12', NULL);
INSERT INTO `sys_menu` VALUES ('19', '4', '删除菜单', NULL, 'sys:menu:delete', NULL, 2, NULL, 3, 1, '2021-01-17 21:56:36', NULL);
INSERT INTO `sys_menu` VALUES ('2', '1', '人员管理', '/sys/users', 'sys:user:list', 'sys/User', 1, 'el-icon-s-custom', 1, 1, '2021-08-14 07:49:55', '2021-08-14 07:49:55');
INSERT INTO `sys_menu` VALUES ('200212122', '7a53a52c9bbfb6d98073c5363ae699aa', '订单管理', '/order/order', 'order:order:list', 'order/Order', 1, 'el-icon-s-goods', 1, 1, '2022-03-15 13:07:37', '2022-03-15 13:07:37');
INSERT INTO `sys_menu` VALUES ('2343242342', '7a53a52c9', '留言管理', '/other/liuyan', 'other:liuyan:list', 'other/Liuyan', 1, 'el-icon-s-opportunity', 1, 1, '2022-04-09 17:35:44', '2022-04-09 17:35:44');
INSERT INTO `sys_menu` VALUES ('234324234234234', '7a53a52c9', '轮播图管理', '/other/lunbo', 'other:lunbo:list', 'other/Carouse', 1, 'el-icon-picture', 1, 1, '2022-04-09 15:56:33', '2022-04-09 15:56:33');
INSERT INTO `sys_menu` VALUES ('3', '1', '角色管理', '/sys/roles', 'sys:role:list', 'sys/Roles', 1, 'el-icon-rank', 2, 1, '2021-01-15 19:03:45', '2021-01-15 19:03:48');
INSERT INTO `sys_menu` VALUES ('4', '1', '菜单管理', '/sys/menus', 'sys:menu:list', 'sys/Menu', 1, 'el-icon-menu', 3, 1, '2021-01-15 19:03:45', '2021-01-15 19:03:48');
INSERT INTO `sys_menu` VALUES ('5', '0', '系统工具', '', 'sys:tools', NULL, 0, 'el-icon-s-tools', 2, 1, '2021-01-15 19:06:11', NULL);
INSERT INTO `sys_menu` VALUES ('6', '5', '数字字典', '/sys/dicts', 'sys:dict:list', 'tools/Dicts', 1, 'el-icon-s-order', 1, 1, '2021-01-15 19:07:18', '2021-01-18 16:32:13');
INSERT INTO `sys_menu` VALUES ('7', '3', '添加角色', '', 'sys:role:save', '', 2, '', 1, 0, '2021-01-15 23:02:25', '2021-01-17 21:53:14');
INSERT INTO `sys_menu` VALUES ('7a53a52c9', '0', '其它模块', '', 'other:manage', NULL, 0, 'el-icon-receiving', 20, 1, '2022-04-09 17:41:06', '2022-04-09 17:41:06');
INSERT INTO `sys_menu` VALUES ('7a53a52c9bbfb', '0', '专题模块', '', 'special:manage', NULL, 0, 'el-icon-postcard', 6, 1, '2022-04-09 15:43:45', '2022-04-09 15:43:45');
INSERT INTO `sys_menu` VALUES ('7a53a52c9bbfb6d98073c5363ae699aa', '0', '订单模块', '', 'order:manage', NULL, 0, 'el-icon-goods', 6, 1, '2022-03-15 11:11:39', '2022-03-15 11:11:39');
INSERT INTO `sys_menu` VALUES ('7a53a52c9bbfb6d98073c5363ae699c1', '0', '用户模块', '', 'people:manage', NULL, 0, 'el-icon-user', 4, 1, '2021-08-14 08:07:15', '2021-08-14 08:07:15');
INSERT INTO `sys_menu` VALUES ('7a53a52c9bbfb6d98073c5363ae699c2', '0', '景点模块', '', 'product:manage', NULL, 0, 'el-icon-camera', 5, 1, '2022-03-15 13:13:32', '2022-03-15 13:13:32');
INSERT INTO `sys_menu` VALUES ('7a53a52c9bbfb6d98073c5363ae699ca', '0', '攻略模块', '', 'gl:manage', NULL, 0, 'el-icon-star-off', 6, 1, '2022-03-15 13:15:03', '2022-03-15 13:15:03');
INSERT INTO `sys_menu` VALUES ('9', '2', '添加用户', NULL, 'sys:user:save', NULL, 2, NULL, 1, 1, '2022-03-14 13:46:43', '2022-03-14 13:46:43');
INSERT INTO `sys_menu` VALUES ('a86e411f7c3c6a6e7f491760612ba24c', '7a53a52c9bbfb6d98073c5363ae699aa', '订单分析', '/order/analyse', 'order:analyse:list', 'product/Analyse', 1, 'el-icon-s-platform', 2, 1, '2022-03-15 13:12:29', '2022-03-15 13:12:29');
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `code` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `remark` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注',
  `status` tinyint(4) NOT NULL,
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`pid`) USING BTREE,
  UNIQUE KEY `name` (`name`) USING BTREE,
  UNIQUE KEY `code` (`code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES ('3', '管理系统用户', 'normal', '只有基本查看功能', 1, '2021-01-04 10:09:14', '2021-01-30 08:19:52');
INSERT INTO `sys_role` VALUES ('6', '飞猫超级管理员', 'admin', '系统默认最高权限，不可以编辑和任意修改', 1, '2021-01-16 13:29:03', '2021-01-17 15:50:45');
INSERT INTO `sys_role` VALUES ('60ccc551e78dbef84119380609a746f5', '商城用户', 'people', '商城用户', 1, '2021-08-14 07:53:25', '2021-08-14 07:53:25');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `pid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `role_pid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `menu_pid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`pid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` VALUES ('0a5af1af474b035621e80155010041d4', '6', '7', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('0e011eedd07efbb1b612ae36e949d930', '6', '18', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('100', '3', '5', '2021-08-13 21:03:52', '2021-08-13 21:03:52');
INSERT INTO `sys_role_menu` VALUES ('101', '3', '6', '2021-08-13 21:03:52', '2021-08-13 21:03:52');
INSERT INTO `sys_role_menu` VALUES ('105687e5438690829695bbedf64514b7', '6', '6', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('119b616fbd53624282eaecb348aa3fe1', '6', '10038989899999898', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('18678d34065e4ff0378274a7e93bf13d', '6', '13', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('1cb962974601efe57a2235b1c6bc341c', '6', '7a53a52c9bbfb6d98073c5363ae699c1', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('2fee48a4eeed0fb344b9ab46bebb95b1', '6', '17', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('35920427187b3d2777d70d36e1afcec2', '6', '7a53a52c9bbfb6d98073c5363ae699ca', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('364930df81241fd0cac248d0c3edf90a', '6', '4', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('4e50082d0d26fc677139cff014e92e24', '6', '1001', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('5460985f3850f7cd60cd783648355ae4', '6', 'a86e411f7c3c6a6e7f491760612ba24c', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('6046926c5105c60b48b31ef0a0533062', '6', '7a53a52c9bbfb6d98073c5363ae699aa', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('61cc79ec21cac0a9d17a02d8aaea0e74', '6', '7a53a52c9bbfb6d98073c5363ae699c2', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('77637305e35fcf28b137e0eef82fe429', '6', '1003', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('7f026a71f24775a285562fb75485389b', '6', '3', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('7f325cb3331562e1312ce652b02962bb', '6', '1000', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('888e740ca02285fa00ed275b08570f54', '6', '7a53a52c9', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('91607d672d31af91ba0b8aa4e5e61134', '6', '7a53a52c9bbfb', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('96', '3', '1', '2021-08-13 21:03:52', '2021-08-13 21:03:52');
INSERT INTO `sys_role_menu` VALUES ('97', '3', '2', '2021-08-13 21:03:52', '2021-08-13 21:03:52');
INSERT INTO `sys_role_menu` VALUES ('98', '3', '3', '2021-08-13 21:03:52', '2021-08-13 21:03:52');
INSERT INTO `sys_role_menu` VALUES ('99', '3', '4', '2021-08-13 21:03:52', '2021-08-13 21:03:52');
INSERT INTO `sys_role_menu` VALUES ('9c31357ab029685ea1f49590be4821f5', '6', '200212122', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('9ca9f499437e44d2a55b64e2d26ee79e', '6', '15', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('9e8fd39f0690b95a4792b70b41e526a3', '6', '9', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('9f5f202fbbb303905ba54743a44699fa', '6', '10', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('9f76253ca526b4b66bfb6b659fe9d738', '6', '2', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('9ff1c7c1a311c03fdb9d4290b79e65cb', '6', '11', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('a435b6096f717f114d67af4faae9461b', '6', '12', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('b1f172d3df8b5b0fc121586e337e0245', '6', '14', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('cd4398e3cab04722c86cdbd9693fb98d', '6', '2343242342', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('d437a5341ffd9bb982220f784a27741b', '6', '5', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('de1ed28d432d90b38a1bacbd0027a982', '6', '100212112', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('dfcb424b9026f3098b71989a05c49e09', '6', '1', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('e9556e32d1ed34353cc804e29c0ebb74', '6', '19', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('f99de301af7ff6cfefc4abc1ef167a40', '6', '234324234234234', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
INSERT INTO `sys_role_menu` VALUES ('fbc92b50289f17cd34faf1547143d7e8', '6', '16', '2022-04-09 15:56:06', '2022-04-09 15:56:06');
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `pid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `username` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `password` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `email` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `city` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL,
  `last_login` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`pid`) USING BTREE,
  UNIQUE KEY `UK_USERNAME` (`username`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES ('1', 'admin', '$2a$10$ORbInOgfWR2Dk..WJRbJCOWTPoRomd1aIg3OTkD7eBtIX3IaPRgla', 'https://img.ikstatic.cn/MTYyODc1ODAxNzI2OCM5MTEjcG5n.png', '123@qq.com', '广州', 1, '2022-05-04 10:30:12', '2022-03-14 12:37:01', '2022-03-14 12:37:01');
INSERT INTO `sys_user` VALUES ('2', 'test', '$2a$10$ORbInOgfWR2Dk..WJRbJCOWTPoRomd1aIg3OTkD7eBtIX3IaPRgla', 'https://img.ikstatic.cn/MTYyODc1ODAxNzI2OCM5MTEjcG5n.png', 'test@qq.com', NULL, 1, '2022-03-14 12:37:02', '2022-03-14 12:37:02', '2022-03-14 12:37:02');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `pid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `user_pid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `role_pid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`pid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` VALUES ('0b148f8d1ba2d9effadd8a08215794c1', '123', '60ccc551e78dbef84119380609a746f5', '2021-08-14 07:53:34', '2021-08-14 07:53:34');
INSERT INTO `sys_user_role` VALUES ('13', '2', '3', '2021-08-13 21:06:53', '2021-08-13 21:06:53');
INSERT INTO `sys_user_role` VALUES ('4', '1', '6', '2021-08-13 21:06:53', '2021-08-13 21:06:53');
INSERT INTO `sys_user_role` VALUES ('56f6d0f759b3c16cc27893b45cc7a65f', '94544c55f6a6956a4c427280b8db2f57', '60ccc551e78dbef84119380609a746f5', '2021-10-05 16:25:18', '2021-10-05 16:25:18');
INSERT INTO `sys_user_role` VALUES ('7', '1', '3', '2021-08-13 21:06:53', '2021-08-13 21:06:53');
COMMIT;

-- ----------------------------
-- Table structure for user_card
-- ----------------------------
DROP TABLE IF EXISTS `user_card`;
CREATE TABLE `user_card` (
  `pid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `user_pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品外键',
  `remark` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `card_status` tinyint(4) DEFAULT NULL COMMENT '订单状态 0购物车(未购买)1待发货 2待收货 3已完成',
  `price` decimal(10,2) DEFAULT NULL COMMENT '总价格',
  `address_pid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pay_type` tinyint(4) DEFAULT NULL COMMENT '支付方式',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`pid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='订单表';

-- ----------------------------
-- Records of user_card
-- ----------------------------
BEGIN;
INSERT INTO `user_card` VALUES ('011ce0e7f45533791053f20c354aef68', '6a5b323f66e6f36874d824c23700cd0d', NULL, 0, NULL, NULL, NULL, '2022-03-19 17:40:10', '2022-03-19 17:40:10');
INSERT INTO `user_card` VALUES ('018a24b7f9e659e22e5e37aba08d4122', '123', NULL, 1, 248.00, NULL, NULL, '2022-04-07 16:33:17', '2022-04-08 00:33:38');
INSERT INTO `user_card` VALUES ('020c7ec0737021a2583ad45d75691ad1', '123', NULL, 0, NULL, NULL, NULL, '2022-05-02 18:49:29', '2022-05-02 18:49:29');
INSERT INTO `user_card` VALUES ('063627675471d2fbd34fc77fd3733017', 'e29fe12b3141963eeb580401ff1825d6', NULL, 1, 11.00, NULL, NULL, '2022-05-04 10:31:04', '2022-05-04 11:10:20');
INSERT INTO `user_card` VALUES ('0d48f377b18454e269a50be5605f772d', '123', NULL, 1, 31.00, NULL, NULL, '2022-04-07 16:28:52', '2022-04-08 00:33:18');
INSERT INTO `user_card` VALUES ('17038d5fb12b5564d969c513583daa75', '47526e37f29673afa6f0e06e21204875', NULL, 0, NULL, NULL, NULL, '2022-03-22 13:22:13', '2022-03-22 13:22:13');
INSERT INTO `user_card` VALUES ('1bded78b20d3cccb6b7cc60382391480', '123', NULL, 1, 0.00, NULL, NULL, '2022-04-09 06:21:30', '2022-04-10 15:07:04');
INSERT INTO `user_card` VALUES ('1ca9830de47838d13cffca69fe556c34', 'c63f055d5080d06e12f76a925c1dbc88', NULL, 0, NULL, NULL, NULL, '2022-03-22 14:59:12', '2022-03-22 14:59:12');
INSERT INTO `user_card` VALUES ('2bc19d1c92dc2f8de537d169412be375', 'e29fe12b3141963eeb580401ff1825d6', NULL, 1, 11.00, NULL, NULL, '2022-05-04 09:43:11', '2022-05-04 09:43:44');
INSERT INTO `user_card` VALUES ('36080a102b059568ad2d6ab088db01d3', '123', NULL, 1, 21.00, NULL, NULL, '2022-05-01 23:26:05', '2022-05-01 23:28:34');
INSERT INTO `user_card` VALUES ('3e8a4a1b3a317164e0987f7c2a92aba9', '123', NULL, 1, 155.00, NULL, NULL, '2022-05-01 23:28:33', '2022-05-01 23:33:20');
INSERT INTO `user_card` VALUES ('49ac56f4e8ed06fc05e36a705c2735f5', '123', NULL, 1, 11.00, NULL, NULL, '2022-05-02 18:44:53', '2022-05-02 18:49:29');
INSERT INTO `user_card` VALUES ('624173c1c8ada839ead431188f12a7f4', '123', NULL, 1, 63.00, NULL, NULL, '2022-04-07 16:33:38', '2022-04-08 00:39:39');
INSERT INTO `user_card` VALUES ('78899ea4a9151e31084b5cc0c373e5af', 'e29fe12b3141963eeb580401ff1825d6', NULL, 0, NULL, NULL, NULL, '2022-05-04 11:27:01', '2022-05-04 11:27:01');
INSERT INTO `user_card` VALUES ('79411470efa735632b458097a2046314', '123', NULL, 1, 21.00, NULL, NULL, '2022-04-07 16:39:39', '2022-04-09 14:21:30');
INSERT INTO `user_card` VALUES ('79615d4d1c08c3e686a440bc0fc72c58', 'e29fe12b3141963eeb580401ff1825d6', NULL, 1, 12.00, NULL, NULL, '2022-05-04 09:43:44', '2022-05-04 09:44:50');
INSERT INTO `user_card` VALUES ('9d05dd5d6058a4fac50552a52d2766b9', '123', NULL, 1, 21.00, NULL, NULL, '2022-05-01 23:33:20', '2022-05-01 23:33:43');
INSERT INTO `user_card` VALUES ('b169b899eb46c8440e8f32dc3118ea54', '123', NULL, 1, 31.00, NULL, NULL, '2022-05-01 23:33:42', '2022-05-02 18:44:53');
INSERT INTO `user_card` VALUES ('b7551a9d650ea9e00d2b9e088c2564c5', '123', NULL, 1, 25.00, NULL, NULL, '2022-04-10 15:07:03', '2022-04-10 17:36:15');
INSERT INTO `user_card` VALUES ('bf80b26ba23f1cf3fba6ae3f1a61276e', 'e29fe12b3141963eeb580401ff1825d6', NULL, 1, 2415.00, NULL, NULL, '2022-05-04 11:12:03', '2022-05-04 11:21:59');
INSERT INTO `user_card` VALUES ('cc350e2bdd7aaee10f86ceb81f6ed8b7', 'e29fe12b3141963eeb580401ff1825d6', NULL, 1, 2511.00, NULL, NULL, '2022-05-04 11:21:58', '2022-05-04 11:27:01');
INSERT INTO `user_card` VALUES ('f16c94d0d0ff89b3c8b1e4cd32543594', 'e29fe12b3141963eeb580401ff1825d6', NULL, 1, 12.00, NULL, NULL, '2022-05-04 11:10:20', '2022-05-04 11:12:03');
INSERT INTO `user_card` VALUES ('f9731f8dc8c6557400df5048daa8c861', 'e29fe12b3141963eeb580401ff1825d6', NULL, 1, 55.00, NULL, NULL, '2022-05-04 09:44:50', '2022-05-04 10:31:05');
INSERT INTO `user_card` VALUES ('fe7224cd01efeabe53940fbf6bbdc61e', '123', NULL, 1, 21.00, NULL, NULL, '2022-04-10 17:36:15', '2022-05-01 23:26:05');
COMMIT;

-- ----------------------------
-- Table structure for user_card_product
-- ----------------------------
DROP TABLE IF EXISTS `user_card_product`;
CREATE TABLE `user_card_product` (
  `pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `card_pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '购物车关联',
  `product_pid` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '景点id',
  `quanity` tinyint(4) DEFAULT NULL COMMENT '商品数量',
  `product_check` tinyint(4) DEFAULT '0' COMMENT '是否选中 0 未 1 选中',
  `price` decimal(10,2) DEFAULT NULL COMMENT '价格',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`pid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='购物车商品';

-- ----------------------------
-- Records of user_card_product
-- ----------------------------
BEGIN;
INSERT INTO `user_card_product` VALUES ('0c5c9749350e6dfca15848a3ce47f190', 'b7551a9d650ea9e00d2b9e088c2564c5', 'b843b1e84d307397821e5063176af551', 1, 1, 25.00, '2022-04-10 17:36:07', '2022-04-10 17:36:07');
INSERT INTO `user_card_product` VALUES ('0ddfa96998022bd88388fede0cb72a33', '3e8a4a1b3a317164e0987f7c2a92aba9', '222', 5, 1, 155.00, '2022-05-01 23:33:05', '2022-05-01 23:33:05');
INSERT INTO `user_card_product` VALUES ('0fcdfc6a875c0f85a1b957b911622dea', '79411470efa735632b458097a2046314', 'f54825904a5a89603550a83ead17cf14', 1, 1, 21.00, '2022-04-09 14:21:20', '2022-04-09 14:21:20');
INSERT INTO `user_card_product` VALUES ('1e16013fd6c4427a72cd636e3897c378', '36080a102b059568ad2d6ab088db01d3', 'c6d097a5da1d7c103817713334e7ad84', 1, 1, 21.00, '2022-05-01 23:28:17', '2022-05-01 23:28:17');
INSERT INTO `user_card_product` VALUES ('221b5528a8031542b38368639ff548a4', 'fe7224cd01efeabe53940fbf6bbdc61e', '233', 1, 1, 21.00, '2022-05-01 23:25:59', '2022-05-01 23:25:59');
INSERT INTO `user_card_product` VALUES ('29e150a04d1d8f669c0d13817d2b0a6a', 'f16c94d0d0ff89b3c8b1e4cd32543594', 'c6d097a5da1d7c103817713334e7ad84', 1, 1, 21.00, '2022-05-04 11:11:44', '2022-05-04 11:11:44');
INSERT INTO `user_card_product` VALUES ('2c88cd7cd24534a10aefe473681606a7', 'f16c94d0d0ff89b3c8b1e4cd32543594', '8c8867de2c376f594dc206d30e592c71', 1, 1, 12.00, '2022-05-04 11:11:39', '2022-05-04 11:11:39');
INSERT INTO `user_card_product` VALUES ('2fb08cd063986725cf564dcf9b818920', 'b169b899eb46c8440e8f32dc3118ea54', '8c8867de2c376f594dc206d30e592c71', 1, 1, 12.00, '2022-05-02 18:44:47', '2022-05-02 18:44:47');
INSERT INTO `user_card_product` VALUES ('33960acb44e5cabd8f14c17cf619b922', '1bded78b20d3cccb6b7cc60382391480', 'c165d72339d57389f57dd28f4acfc314', 1, 1, 0.00, '2022-04-10 15:06:53', '2022-04-10 15:06:53');
INSERT INTO `user_card_product` VALUES ('34dbb863c9cd2166e30f1f05726de375', '36080a102b059568ad2d6ab088db01d3', '233', 1, 1, 21.00, '2022-05-01 23:28:02', '2022-05-01 23:28:02');
INSERT INTO `user_card_product` VALUES ('40454357ed937e50e3732370e4af1ca0', '36080a102b059568ad2d6ab088db01d3', 'b843b1e84d307397821e5063176af551', 1, 1, 25.00, '2022-05-01 23:28:12', '2022-05-01 23:28:12');
INSERT INTO `user_card_product` VALUES ('40a58a097fdb251d03cab0e264780032', '0d48f377b18454e269a50be5605f772d', '222', 1, 1, 31.00, '2022-04-08 00:33:07', '2022-04-08 00:33:07');
INSERT INTO `user_card_product` VALUES ('4121ff9df1d30a93bc2588b7de49c7c0', '49ac56f4e8ed06fc05e36a705c2735f5', '8c8867de2c376f594dc206d30e592c71', 2, 1, 24.00, '2022-05-02 18:48:39', '2022-05-02 18:48:39');
INSERT INTO `user_card_product` VALUES ('4edc55c8b934e78a6881e23c391b0a11', 'cc350e2bdd7aaee10f86ceb81f6ed8b7', '222', 81, 1, 2511.00, '2022-05-04 11:26:29', '2022-05-04 11:26:29');
INSERT INTO `user_card_product` VALUES ('4f720e5aa22e91e1ebba4b0b141869e0', '063627675471d2fbd34fc77fd3733017', '4abd7ec701a27d322ddf404d4fa37892', 1, 1, 11.00, '2022-05-04 11:10:14', '2022-05-04 11:10:14');
INSERT INTO `user_card_product` VALUES ('4f96d6f0ecfadb98dbca2ed7e5dfe646', '49ac56f4e8ed06fc05e36a705c2735f5', 'b843b1e84d307397821e5063176af551', 1, 1, 25.00, '2022-05-02 18:48:45', '2022-05-02 18:48:45');
INSERT INTO `user_card_product` VALUES ('518babc097ab1087c2b9f155f1b0cfa7', '36080a102b059568ad2d6ab088db01d3', '83bc3c6a2790efd69f74ff95acab9687', 1, 1, 11.00, '2022-05-01 23:28:23', '2022-05-01 23:28:23');
INSERT INTO `user_card_product` VALUES ('59e6272fdc8c12155e3d7704b6fff7a3', '49ac56f4e8ed06fc05e36a705c2735f5', '83bc3c6a2790efd69f74ff95acab9687', 1, 1, 11.00, '2022-05-02 18:48:55', '2022-05-02 18:48:55');
INSERT INTO `user_card_product` VALUES ('5b34a6dd0872368573229b32ad8d8d55', '49ac56f4e8ed06fc05e36a705c2735f5', '4abd7ec701a27d322ddf404d4fa37892', 1, 1, 11.00, '2022-05-02 18:48:34', '2022-05-02 18:48:34');
INSERT INTO `user_card_product` VALUES ('816c0dde4d1e4cf7b3bc347bb44a1e3a', 'b169b899eb46c8440e8f32dc3118ea54', '222', 1, 1, 31.00, '2022-05-01 23:38:58', '2022-05-01 23:38:58');
INSERT INTO `user_card_product` VALUES ('8832ca61e8f35657194ecb6c4b40ae05', 'f9731f8dc8c6557400df5048daa8c861', '4abd7ec701a27d322ddf404d4fa37892', 5, 1, 55.00, '2022-05-04 10:30:59', '2022-05-04 10:30:59');
INSERT INTO `user_card_product` VALUES ('8d5241077cf582477b5b5de4766055ac', '018a24b7f9e659e22e5e37aba08d4122', '222', 9, 1, 248.00, '2022-04-07 16:37:14', '2022-04-07 16:37:14');
INSERT INTO `user_card_product` VALUES ('9b2bcf455ea4f30c15de1e5d0117bc70', '624173c1c8ada839ead431188f12a7f4', 'f54825904a5a89603550a83ead17cf14', 3, 1, 63.00, '2022-04-08 00:39:27', '2022-04-08 00:39:27');
INSERT INTO `user_card_product` VALUES ('ad8bfde2ed3809c4fdfdbe8e1ceab4a4', '79615d4d1c08c3e686a440bc0fc72c58', '8c8867de2c376f594dc206d30e592c71', 1, 1, 12.00, '2022-05-04 09:44:41', '2022-05-04 09:44:41');
INSERT INTO `user_card_product` VALUES ('b1a49b85c6548a29e80285fa3f41e4ab', '3e8a4a1b3a317164e0987f7c2a92aba9', '233', 2, 1, 42.00, '2022-05-01 23:33:14', '2022-05-01 23:33:14');
INSERT INTO `user_card_product` VALUES ('b41528898c623954abc0eeb3ff9a38fd', '9d05dd5d6058a4fac50552a52d2766b9', 'f54825904a5a89603550a83ead17cf14', 1, 1, 21.00, '2022-05-01 23:33:36', '2022-05-01 23:33:36');
INSERT INTO `user_card_product` VALUES ('b4a5aa5d411e1d3b2fc4095d129bcb59', 'f16c94d0d0ff89b3c8b1e4cd32543594', '233', 1, 1, 21.00, '2022-05-04 11:11:53', '2022-05-04 11:11:53');
INSERT INTO `user_card_product` VALUES ('c00ad9adb142f96d6ca2b6a3c4b0ef51', 'f16c94d0d0ff89b3c8b1e4cd32543594', 'f54825904a5a89603550a83ead17cf14', 1, 1, 21.00, '2022-05-04 11:11:57', '2022-05-04 11:11:57');
INSERT INTO `user_card_product` VALUES ('ce180c7fe312cfb5c90b52023fecba93', '2bc19d1c92dc2f8de537d169412be375', '4abd7ec701a27d322ddf404d4fa37892', 1, 1, 11.00, '2022-05-04 09:43:38', '2022-05-04 09:43:38');
INSERT INTO `user_card_product` VALUES ('d054e237f71443ef2f2dd8b49fafffad', 'f16c94d0d0ff89b3c8b1e4cd32543594', 'b843b1e84d307397821e5063176af551', 1, 1, 25.00, '2022-05-04 11:11:47', '2022-05-04 11:11:47');
INSERT INTO `user_card_product` VALUES ('d6e243679312918c13ffba84df0c887c', '49ac56f4e8ed06fc05e36a705c2735f5', '233', 2, 1, 42.00, '2022-05-02 18:48:49', '2022-05-02 18:48:49');
INSERT INTO `user_card_product` VALUES ('efd25c339eb9365ae575d44e9505f9f2', '36080a102b059568ad2d6ab088db01d3', 'c165d72339d57389f57dd28f4acfc314', 1, 1, 0.00, '2022-05-01 23:28:20', '2022-05-01 23:28:20');
INSERT INTO `user_card_product` VALUES ('f5f1acd7a9896dfdfcf1bee0138971d6', 'f16c94d0d0ff89b3c8b1e4cd32543594', '222', 1, 1, 31.00, '2022-05-04 11:11:50', '2022-05-04 11:11:50');
INSERT INTO `user_card_product` VALUES ('fe3b4a3e95bc4fdea4638b8e5f5ffc57', 'bf80b26ba23f1cf3fba6ae3f1a61276e', 'f54825904a5a89603550a83ead17cf14', 115, 1, 2415.00, '2022-05-04 11:21:19', '2022-05-04 11:21:19');
COMMIT;

-- ----------------------------
-- Table structure for user_collect
-- ----------------------------
DROP TABLE IF EXISTS `user_collect`;
CREATE TABLE `user_collect` (
  `pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `user_pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户id',
  `product_pid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '商品pid',
  `collect_status` tinyint(4) DEFAULT '1' COMMENT '状态',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`pid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户收藏';

-- ----------------------------
-- Records of user_collect
-- ----------------------------
BEGIN;
INSERT INTO `user_collect` VALUES ('989421c34b29d72d1d738e53a936ea19', '6a5b323f66e6f36874d824c23700cd0d', '83bc3c6a2790efd69f74ff95acab9687', 1, '2022-03-19 18:43:00', '2022-03-19 18:43:00');
INSERT INTO `user_collect` VALUES ('af83d403aafcc05e0328550ea56e2328', '123', 'f54825904a5a89603550a83ead17cf14', 1, '2022-04-09 05:34:04', '2022-04-09 05:34:04');
INSERT INTO `user_collect` VALUES ('bd86146000d0b39d5c694bbf5987ea5c', 'e29fe12b3141963eeb580401ff1825d6', '8c8867de2c376f594dc206d30e592c71', 1, '2022-05-04 09:43:58', '2022-05-04 09:43:58');
INSERT INTO `user_collect` VALUES ('e84632290df573687379422286a71ef1', 'e29fe12b3141963eeb580401ff1825d6', '4abd7ec701a27d322ddf404d4fa37892', 1, '2022-05-04 09:43:52', '2022-05-04 09:43:52');
COMMIT;

-- ----------------------------
-- Table structure for user_comment
-- ----------------------------
DROP TABLE IF EXISTS `user_comment`;
CREATE TABLE `user_comment` (
  `pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `user_pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户id',
  `user_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '名字',
  `product_pid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '景点pid',
  `email` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '邮箱',
  `content` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '1' COMMENT '评论内容',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`pid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='评论表\n';

-- ----------------------------
-- Records of user_comment
-- ----------------------------
BEGIN;
INSERT INTO `user_comment` VALUES ('037dfa5f1d6c29cf91a6535f9990b399', '123', 'mxy0618', '', 'faefae', '很好的站点', '2022-05-02 16:16:17', '2022-05-02 16:16:17');
INSERT INTO `user_comment` VALUES ('293348f4f7d233733384fb1eadec2384', '123', 'mxy0618', '', 'fesefs', '景点都很好', '2022-05-02 16:16:21', '2022-05-02 16:16:21');
INSERT INTO `user_comment` VALUES ('2bd2459f100e7f1c4813b66c065f28e4', '123', 'mxy0618', '', 'faefaefa', '希望平台能够给予更多优惠😁', '2022-05-02 15:13:38', '2022-05-02 15:13:38');
INSERT INTO `user_comment` VALUES ('2d3db4a5ea40e996ccf60ceda6562340', '123', 'mxy0618', '', 'feafsaer', 'feafsaerfeafsaerfeafsaerfeafsaer', '2022-05-02 16:03:03', '2022-05-02 16:03:03');
INSERT INTO `user_comment` VALUES ('542510bede7b25f38f476ce14affe3c5', '123', 'mxy0618', '', 'afeafefsae', '查询功能有问题，希望尽快修复', '2022-05-02 15:13:42', '2022-05-02 15:13:42');
INSERT INTO `user_comment` VALUES ('57186a929efeb4aa00fc9ea56b90bbb7', '123', 'mxy0618', '', 'faefea', '希望越来越好', '2022-05-02 16:16:31', '2022-05-02 16:16:31');
INSERT INTO `user_comment` VALUES ('57ffa1083dc302788939af7cb3c1c86b', '123', 'mxy0618', '', 'afeafefsae', '好啊好', '2022-05-02 16:16:38', '2022-05-02 16:16:38');
COMMIT;

-- ----------------------------
-- Table structure for user_info
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
  `pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `phone` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '登录使用的手机号',
  `user_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户名',
  `password` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '密码',
  `qq` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '即时通讯',
  `email` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '邮箱',
  `product_num` int(11) DEFAULT '0' COMMENT '发布过的景点数量',
  `power` int(11) DEFAULT '60' COMMENT '信用分，普通用户默认为100',
  `user_status` tinyint(4) DEFAULT '0' COMMENT '账号是否冻结，默认0未冻结',
  `last_login` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最近一次登陆时间',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`pid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户表';

-- ----------------------------
-- Records of user_info
-- ----------------------------
BEGIN;
INSERT INTO `user_info` VALUES ('123', '1', 'mxy0618', '$2a$10$k/uj/Umu.BWBCrm2EeLcM.RI96am5oBP0Qygo4qcowOvxyG9t78YO', '123', '123@qq.com', 5, 60, 1, '2022-04-10 14:34:24', '2022-03-16 20:20:14', '2022-03-16 20:20:14');
INSERT INTO `user_info` VALUES ('47526e37f29673afa6f0e06e21204875', '19999999999', '我是测试呢', '$2a$10$WnhhGlaRzrPEWRtmzZGXxuZ6fzgxEQAI6Rv6UseS6M/VBADTX4cBO', '19999999999', '19999999999@qq.com', 0, 60, 1, '2022-03-22 13:22:13', '2022-03-22 13:22:13', '2022-03-22 13:22:13');
INSERT INTO `user_info` VALUES ('6a5b323f66e6f36874d824c23700cd0d', '111111', '清风与酒', '$2a$10$0z99GN5985AcxiJ2xZ39ceDxTayECImve7GUQfA7SNT33Q31l2mdm', '111111', '111111@qq.com', 0, 60, 1, '2022-03-19 17:40:10', '2022-03-19 17:40:10', '2022-03-19 17:40:10');
INSERT INTO `user_info` VALUES ('94544c55f6a6956a4c427280b8db2f11', '17194927123', '寂寞的天使', '$2a$10$k/uj/Umu.BWBCrm2EeLcM.RI96am5oBP0Qygo4qcowOvxyG9t78YO', '1231231', '1231231@qq.com', 0, 60, 1, '2022-03-15 10:08:09', '2022-03-15 10:08:09', '2022-03-15 10:08:09');
INSERT INTO `user_info` VALUES ('94544c55f6a6956a4c427280b8db2f12', '16694927123', '树熊', '$2a$10$k/uj/Umu.BWBCrm2EeLcM.RI96am5oBP0Qygo4qcowOvxyG9t78YO', '23432523', '23432523@qq.com', 0, 60, 1, '2022-03-15 10:08:21', '2022-03-15 10:08:21', '2022-03-15 10:08:21');
INSERT INTO `user_info` VALUES ('94544c55f6a6956a4c427280b8db2f13', '13694927123', '摄影师么么锐', '$2a$10$k/uj/Umu.BWBCrm2EeLcM.RI96am5oBP0Qygo4qcowOvxyG9t78YO', '2342353', '2342353@qq.com', 0, 60, 1, '2022-03-15 10:09:00', '2022-03-15 10:09:00', '2022-03-15 10:09:00');
INSERT INTO `user_info` VALUES ('94544c55f6a6956a4c427280b8db2f14', '15634927123', '小樱子angel', '$2a$10$k/uj/Umu.BWBCrm2EeLcM.RI96am5oBP0Qygo4qcowOvxyG9t78YO', '654653345', '654653345@qq.com', 0, 60, 1, '2022-03-15 10:09:24', '2022-03-15 10:09:24', '2022-03-15 10:09:24');
INSERT INTO `user_info` VALUES ('94544c55f6a6956a4c427280b8db2f40', '15634927123', '滢萱', '$2a$10$k/uj/Umu.BWBCrm2EeLcM.RI96am5oBP0Qygo4qcowOvxyG9t78YO', '123123123', '123123123@qq.com', 0, 60, 1, '2022-03-15 10:09:34', '2022-03-15 10:09:34', '2022-03-15 10:09:34');
INSERT INTO `user_info` VALUES ('94544c55f6a6956a4c427280b8db2f41', '15649927123', ' 苏丹卿', '$2a$10$k/uj/Umu.BWBCrm2EeLcM.RI96am5oBP0Qygo4qcowOvxyG9t78YO', '124323423', '124323423@qq.com', 0, 60, 1, '2022-03-15 10:10:08', '2022-03-15 10:10:08', '2022-03-15 10:10:08');
INSERT INTO `user_info` VALUES ('94544c55f6a6956a4c427280b8db2f42', '15634935123', '忘记时间', '$2a$10$k/uj/Umu.BWBCrm2EeLcM.RI96am5oBP0Qygo4qcowOvxyG9t78YO', '1231312311', '1231312311@qq.com', 0, 60, 1, '2022-03-20 23:10:42', '2022-03-20 23:10:42', '2022-03-20 23:10:42');
INSERT INTO `user_info` VALUES ('94544c55f6a6956a4c427280b8db2f55', '17694927123', 'duck_ye', '$2a$10$k/uj/Umu.BWBCrm2EeLcM.RI96am5oBP0Qygo4qcowOvxyG9t78YO', '12222222', '12222222@qq.com', 0, 60, 1, '2022-03-15 10:09:59', '2022-03-15 10:09:59', '2022-03-15 10:09:59');
INSERT INTO `user_info` VALUES ('94544c55f6a6956a4c427280b8db2f56', '17694927168', '验客小编', '$2a$10$k/uj/Umu.BWBCrm2EeLcM.RI96am5oBP0Qygo4qcowOvxyG9t78YO', '62222222', '62222222@qq.com', 0, 60, 1, '2022-03-15 10:09:49', '2022-03-15 10:09:49', '2022-03-15 10:09:49');
INSERT INTO `user_info` VALUES ('94544c55f6a6956a4c427280b8db2f57', '17694927166', '小小小苔藓', '$2a$10$k/uj/Umu.BWBCrm2EeLcM.RI96am5oBP0Qygo4qcowOvxyG9t78YO', '32222222', '32222222@qq.com', 0, 60, 1, '2022-03-15 10:09:10', '2022-03-15 10:09:10', '2022-03-15 10:09:10');
INSERT INTO `user_info` VALUES ('c63f055d5080d06e12f76a925c1dbc88', '11111111122121', '测试用户呢', '$2a$10$rTDh0pT48S6cdZDYH.cMP.uAYKMHb1pkMiQ6wZW9x9ZHei/4WauOu', '11111111', '11111111@qq.com', 0, 60, 1, '2022-03-22 14:59:12', '2022-03-22 14:59:12', '2022-03-22 14:59:12');
INSERT INTO `user_info` VALUES ('e29fe12b3141963eeb580401ff1825d6', '132131231231', '承德旅游网内测账号', '$2a$10$S/NMyuAKgx9Q9LDR9VB0KeG2g2SEXD948eIkKM4SYI5YGSdBpV4tu', '132131231231', '132131231231@qq.com', 0, 60, 1, '2022-05-04 09:43:11', '2022-05-04 09:43:11', '2022-05-04 09:43:11');
COMMIT;

-- ----------------------------
-- Table structure for user_notice
-- ----------------------------
DROP TABLE IF EXISTS `user_notice`;
CREATE TABLE `user_notice` (
  `pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `user_pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户，外键',
  `context` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '信息内容',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态，0未读，1已读',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`pid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='通知表';

-- ----------------------------
-- Records of user_notice
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for user_purse
-- ----------------------------
DROP TABLE IF EXISTS `user_purse`;
CREATE TABLE `user_purse` (
  `pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `user_pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户，外键',
  `balance` decimal(10,2) DEFAULT NULL COMMENT '总钱数',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态，0未读，1已读',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`pid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='钱包';

-- ----------------------------
-- Records of user_purse
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for user_puse_record
-- ----------------------------
DROP TABLE IF EXISTS `user_puse_record`;
CREATE TABLE `user_puse_record` (
  `pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `user_pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户，外键',
  `purse_pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户，外键',
  `money` decimal(10,2) DEFAULT NULL COMMENT '操作钱数',
  `status` tinyint(4) DEFAULT NULL COMMENT '0未审核1审核中2申请失败3已审核',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`pid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='钱包';

-- ----------------------------
-- Records of user_puse_record
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for user_reply
-- ----------------------------
DROP TABLE IF EXISTS `user_reply`;
CREATE TABLE `user_reply` (
  `pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `user_pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户，外键',
  `atuser_pid` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `commet_pid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '评论，外键',
  `content` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '回复内容',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`pid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='回复表';

-- ----------------------------
-- Records of user_reply
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for user_school_check
-- ----------------------------
DROP TABLE IF EXISTS `user_school_check`;
CREATE TABLE `user_school_check` (
  `pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `user_pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户，外键',
  `check_status` tinyint(4) DEFAULT NULL COMMENT '0审核中1审核失败2审核成功',
  `school_num` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '学号',
  `school_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL COMMENT '状态',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`pid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='学生认证';

-- ----------------------------
-- Records of user_school_check
-- ----------------------------
BEGIN;
INSERT INTO `user_school_check` VALUES ('1', '123', 2, '130827199908276625', '河北', 1, '2022-03-15 10:12:57', '2022-03-15 10:12:57');
INSERT INTO `user_school_check` VALUES ('2', '94544c55f6a6956a4c427280b8db2f56', 2, '139827199907263321', '北京', 1, '2022-03-15 10:13:10', '2022-03-15 10:13:10');
INSERT INTO `user_school_check` VALUES ('3', '94544c55f6a6956a4c427280b8db2f57', 2, '130827200008261433', '天津', 1, '2022-03-15 10:13:23', '2022-03-15 10:13:23');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
